Ask Your Question
0

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:

=EOMONTH(K1,0)

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
0

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

pierre-yves samyn gravatar image

Hi

If you want the previous month, you can try

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

Regards

edit flag offensive delete link more

Comments

Thank you!

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

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

JohnSUN gravatar image

What about

=EOMONTH(K1,-1)+1
edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower

Stats

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

Seen: 2,721 times

Last updated: Oct 04 '16