get first day of month sheets code example Example: first day of the month google sheets =EOMONTH(TODAY(),-1)+1