Date of the First day of the previous month

[Hari]

Hi,

If am given a date like let say, 24-Jan-2006, how would I get the date
1-Dec-2005?

Presently I have used some seemingly complicated formula to get the
first day of the previous month. I have used convoluted combination of
DATE and EODATE function to achieve the same.

I have 2 issues with this

a) Probably there is an easy way to do this without using EODATE
function

b) This worksheet wont work for those who doesnt have Analysis Toolpak
Add-in installed.

Is there an alternate way for this?

Please guide me.

Regards,
HP
India

 

[Leo Heuser]

Hi,

If am given a date like let say, 24-Jan-2006, how would I get the date
1-Dec-2005?

Presently I have used some seemingly complicated formula to get the
first day of the previous month. I have used convoluted combination of
DATE and EODATE function to achieve the same.

I have 2 issues with this

a) Probably there is an easy way to do this without using EODATE
function

b) This worksheet wont work for those who doesnt have Analysis Toolpak
Add-in installed.

Is there an alternate way for this?

Please guide me.

Regards,
HP
India

Hi HP

One way, with known date in C2:

=DATE(YEAR(C2),MONTH(C2)-1,1)

 

[Hari]

Leo,

Thanks a lot. I feel really stupid to not try this. I thought that
Month(C2) -1 would give "error" in case value of Month is 1. So, I
didnt even try it out.

Regards,
HP
India

 

[Leo Heuser]

Leo,

Thanks a lot. I feel really stupid to not try this. I thought that
Month(C2) -1 would give "error" in case value of Month is 1. So, I
didnt even try it out.

Regards,
HP
India

You are welcome and thanks for the feedback.
I know the feeling ;-)

Regards
Leo