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