Posted to microsoft.public.excel.misc

external usenet poster

Posts: 234

Advancing the year

I have a date in C3 (October 12, 2009) and would like cell d3 to display that
same day, but 3 years later (October 12, 2012). Is there a formula that I
can use to make that happen?

Thanks!

JT

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
Advancing One row without enter	furstwinhall	Excel Discussion (Misc queries)	6	May 19th 08 11:44 PM
Advancing formula	spankydata	Excel Worksheet Functions	3	August 10th 06 09:49 AM
Advancing Timing	lsmft	Excel Discussion (Misc queries)	2	April 9th 06 04:04 PM
how can I stop Excel Advancing the year by 1 when I enter a date?	Priscilla	Excel Discussion (Misc queries)	4	April 1st 06 02:55 PM
Advancing Down A List	Minitman	Excel Worksheet Functions	6	December 6th 05 02:44 AM

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

About Us

"It's about Microsoft Excel"

Menu

About Us