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