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? If you had your base date in A1, this will return the date of the last day of the previous month: For the date of the first day of the previous month, this is the shortest way:

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

4 Answers

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) 
3

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

0

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).

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.

ncG1vNJzZmirpJawrLvVnqmfpJ%2Bse6S7zGiorp2jqbawutJoamppYWh%2FdX2OrZ%2BeZZyWwLV506GcZp6Zp8C1ecOasGanlmKubrnOp6uhZZmjeqi7zqCjnmWjnbKmwNI%3D

 Share!