Month Calculation

[Jamie]

I've got a spreadsheet and in cell A2 the user will input
a date. I'm trying to provide a calculation for cell B2
that will subtract 1 month from the date in cell A2.

For instance, if the user types in December 12, 2003, then
cell B2 would calculate to November 12, 2003. Of if they
type in March 3, 2004, cell B2 would calculate to February
3, 2004. Of course the calculation would have to take
into consideration that some months have 30 or 31 days and
in the case of February 28 or 29 days.

Any assistance someone could provide to me would be
greatly appreciated.

Thanks,

Jamie

 

[macropod]

Hi Jamie,

To see how to do this, go to:
http://www.wopr.com/cgi-bin/w3t/showflat.pl?Cat=&Board=wrd&Number=249902
(url all one line)
Where you can download a Word document that uses fields to do this and much
more with dates.

Cheers