Posted to microsoft.public.excel.misc

Vicki

external usenet poster

Posts: 70

anniversary dates

How do I get a date in the past (column a) to show as a due date this year in
column b? i.e. if they joined the company on 3-dec-98 then I want the next
column to automatically say that their appraisal is due on 3-dec-07. THANKS

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
Date range selection? Anniversary dates	mrburnette	Excel Worksheet Functions	6	August 30th 07 07:16 PM
Days to next anniversary	smaruzzi	Excel Discussion (Misc queries)	36	July 10th 07 05:44 AM
Calculating Anniversary	Penny	Excel Discussion (Misc queries)	5	October 7th 05 03:31 PM
recurring anniversary dates	Blackhawk	Excel Discussion (Misc queries)	0	August 2nd 05 06:21 AM
How do I get an anniversary date?	Steve j.	Excel Worksheet Functions	1	November 18th 04 04:10 PM

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

About Us

"It's about Microsoft Excel"

Menu

About Us