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
Bookmarks