Ask Your Question

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

asked 2016-10-04 13:47:26 +0200

member745 gravatar image

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:


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

edit retag flag offensive close merge delete

2 Answers

Sort by » oldest newest most voted

answered 2016-10-04 17:12:43 +0200

pierre-yves samyn gravatar image


If you want the previous month, you can try

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


edit flag offensive delete link more


Thank you!

member745 gravatar imagemember745 ( 2016-10-05 15:10:13 +0200 )edit

answered 2016-10-04 15:06:47 +0200

JohnSUN gravatar image

What about

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2016-10-04 13:47:26 +0200

Seen: 2,721 times

Last updated: Oct 04 '16