How to get first day of month (opposite of EOMONTH)

[member745]

Given today’s date e.g. 2016-10-04 I need to get the values of the first and last day of the previous month 2016-09-01 and 2016-09-30, I can get the last day by:

=EOMONTH(K1,0)

But do not know how to get the first day. Basically the opposite of the EOMONTH function.

[JohnSUN]

What about

=EOMONTH(K1,-1)+1

[PYS]

Hi

If you want the previous month, you can try

• First: =EOMONTH(K1,-2)+1
• Last: =EOMONTH(K1,-1)

Regards

[member745]

Thank you!