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

google-sheets formula worksheet-function
mike1789 picture mike1789 · Jun 29, 2015 · Viewed 25.9k times · Source

What is the way to get the first and last day of the previous month in Google Spreadsheet? I tried several ways to solve this issue with no success.

Answer

ZygD picture ZygD · Jun 29, 2015

If you had your base date in A1,
the following formula would be good for the first day of the previous month:

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

It's even simpler to find the last day of the previous month:

=eomonth(A1,-1)

Related questions

How to utilize date add function in Google spreadsheet?

I believe the issue I am having now should be much easier in MS Excel. However, since my company uses Google Spreadsheet so I have to figure out a way. Basically, I have a cell that contains a date value …

Read More
How to extract URL from Link in Google Sheets using a formula?

I have copied from a website a series of hyperlinks and pasted them in a google sheet. The values show up as linked text, not hyperlink formulas, and are still linked correctly. For each row, I'm trying to extract the …

Read More
Create in-cell dropdown with filtered range

I'm using Google Spreadsheet. To illustrate my problem, I use the range A2:A8 for the data validation of D2 and E2. But because in cell D2, you are supposed to select an animal only, I'd like to filter the …

Read More