"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.