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

"Hari" skrev i en meddelelse
ups.com...
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)


--
Best regards
Leo Heuser

Followup to newsgroup only please.

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

"Hari" skrev i en meddelelse
ups.com...
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