Posted to microsoft.public.excel.programming

Oldjay[_2_] Oldjay[_2_] is offline

external usenet poster

Posts: 9

Date + one year

I have a long column of birthdays formulated 8/12/05
I want to change all the dates to next year i.e. 8/12/06

oldjay

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(Year,Month,Day) not returnign correct date	jlclyde	Excel Discussion (Misc queries)	8	October 16th 09 02:42 PM
Determine year over year date for comparison	zeroscou	Excel Worksheet Functions	3	March 6th 09 10:01 PM
Sorting a date by month, date and then year.	drosh	Excel Discussion (Misc queries)	3	May 30th 08 01:57 AM
Year-to-date year to date formula	Philm	Excel Worksheet Functions	1	October 7th 05 02:50 AM
Date formula: return Quarter and Fiscal Year of a date	Rob	Excel Discussion (Misc queries)	7	May 11th 05 08:48 PM

All times are GMT +1. The time now is 08:10 PM.

About Us

"It's about Microsoft Excel"