LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 9
Default next anniversary date

I want to calculate an employee's next anniversary date. If an employee was
hired earlier this year I need the date to reflect next year. Some
anniversary dates have already occured this year so changing the year of the
hire date to the current year won't work.
 
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 do I find age in years from anniversary date (Age funtion)? Enquire Excel Worksheet Functions 1 January 1st 08 03:37 PM
Date range selection? Anniversary dates mrburnette Excel Worksheet Functions 6 August 30th 07 07:16 PM
Anniversary of a date Becks Excel Discussion (Misc queries) 4 August 23rd 07 02:38 PM
formula to display anniversary date sharita Excel Worksheet Functions 3 February 12th 07 11:57 PM
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 09:30 PM.

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"