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