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