LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.newusers
Oldjay
 
Posts: n/a
Default Change date by one year

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

oldjay


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

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
How to Change Date Formats Jessica Excel Discussion (Misc queries) 2 November 1st 05 06:21 PM
Change general format to US date format woodlot4 Excel Discussion (Misc queries) 3 October 11th 05 12:29 AM
How would I change a date cell to decrease it by business days? CNGracin Excel Discussion (Misc queries) 3 December 15th 04 05:20 PM
How do you change the date to a Number help me Excel Discussion (Misc queries) 8 December 15th 04 07:54 AM
How do I set date to change automatically on invoices created wit. Angel New Users to Excel 3 November 30th 04 04:10 AM


All times are GMT +1. The time now is 05:01 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"