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

=today()

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