CODEWITHSUNDEEP
dategoogle-sheetsgoogle-sheets-formulaformulaworksheet-function
mike1789
mike1789

Reputation: 143

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?

Upvotes: 13

Views: 37896

Answers (4)

ZygD
ZygD

Reputation: 24356

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)

Upvotes: 26

Kelly Rowe
Kelly Rowe

Reputation: 1

Cell A1 To Contain:

=eomonth(A2,-1)+1

Cell A2 To Contain:

=Eomonth(now(),)

if instead of using "now()" you can put in another cells reference, or even do a query/importrange for a particular cell from a different sheet and make these dates even more dynamic.

Upvotes: 0

Richard de Ree
Richard de Ree

Reputation: 2540

for the last day of the previous month (international)

=eomonth(now();-1)

for the last day of the previous month (USA)

 =eomonth(now(),-1)

for the first day of the previous month (international)

=eomonth(now();-2)+1

for the first day of the previous month (USA)

    =eomonth(now(),-2)+1

Demo:

enter image description here

Upvotes: 5

elyhim
elyhim

Reputation: 21

Use =eomonth((eomonth(today(),0)),-2)+1 for use when you want previous from today.

For the last day of the previous month, use =eomonth((eomonth(today(),0)),-1).

Upvotes: 1

Related Questions