Joan

Posts: n/a

Excel Adding years or months to a date

I want to be able to add months or years to a date.

For example 25/4/05 + 9 months
25/4/05 + 15 years.

I am using Excel 2000.

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Adding hours to a date	Rich	Excel Worksheet Functions	6	November 28th 06 08:50 PM
Despite formatting a column in Excel 2002 worksheet as Short Date.	Pete Whalley	Excel Discussion (Misc queries)	2	February 7th 05 06:17 PM
sum automatically from last 12 months based on current date	CDSchomaker	Excel Worksheet Functions	2	December 30th 04 05:28 PM
Auto date changing in Excel is maddening	brhicks	Charts and Charting in Excel	3	December 16th 04 02:54 PM
Creating a Date Selector in Excel VBA?	Mark	Excel Discussion (Misc queries)	0	November 25th 04 10:59 PM

All times are GMT +1. The time now is 12:10 AM.

About Us

"It's about Microsoft Excel"