rogerm

Posts: n/a

how do i add 1 year to a date formatted cell?

I would like to increase the year in a MM/DD/YYYY formated cell by 1, 2,5 and
10 and place the new dates in other cells. Adding 365 doesn't work because
of leap years. Any suggestions?

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
Possible Lookup Table	Karen	Excel Worksheet Functions	5	June 8th 05 09:43 PM
Need to use IF formula with a Date cell	Eric Mc	Excel Worksheet Functions	2	June 8th 05 12:38 AM
Addition to Turn cell red if today is greater or equal to date in cell	Rich	New Users to Excel	2	December 9th 04 02:06 AM
cell assumes wrong date	julie from Seattle	Setting up and Configuration of Excel	1	November 30th 04 07:51 PM
Extract date from cell	Eric	Excel Worksheet Functions	3	November 4th 04 06:37 PM

All times are GMT +1. The time now is 08:44 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us