Return the first day of the Month in Google Sheets

No need to kick in your computer screen. Here’s the functions to return the first day of the month in Google sheets, or the last day of the previous month or the current day.

Function in Google Sheets to return the first day of the current month

=eomonth(today(),-1)+1

last day of the previous month

=eomonth(today(),-1)

Current day function in Google Sheets

=today()

These return the value in mm/dd/yyyy format.