Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Word / Mailmerge and Fax / December 2003

Tip: Looking for answers? Try searching our database.

Month Calculation

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Jamie - 11 Dec 2003 17:59 GMT
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 - 11 Dec 2003 21:03 GMT
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

> 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
[quoted text clipped - 13 lines]
>
> Jamie
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.