Search code examples
dategoogle-sheetsgoogle-sheets-formulaformulaworksheet-function

The last & the first day of a month in Google Sheets

How to get the first and last day of the previous month in Google Sheets?

Solution

  • If you had your base date in A1,
    this will return the date of the last day of the previous month:

    =eomonth(A1,-1)

    For the date of the first day of the previous month, this is the shortest way:

    =eomonth(A1,-2)+1

    Also possible:

    =date(year(A1),month(A1)-1,1)