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