LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Junior Member
 
Posts: 2
Default Date Functions

I need to calculate with a formula the date of someones next birthday based upon a pre-determined date. For example, I need to calculate the date of a person's birthday based upon a start date at work:

Start Date - 12/2/1999
Birth Date - 08/01/1956
Formula Result - 08/01/2000 because that would be the next birthday for this individual based upon the start date of 12/2/1999.

I simply cannot figure out how to do this with a formula - can anyone help? I'm using Excel 2010 in Window's 7.

Thanks,
Robert G
 
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
Date Functions Keith Excel Discussion (Misc queries) 2 April 24th 06 06:43 PM
date functions TUNGANA KURMA RAJU Excel Discussion (Misc queries) 6 January 5th 06 04:29 AM
date functions VDan Excel Discussion (Misc queries) 1 August 31st 05 06:24 PM
Date functions John New Users to Excel 3 August 15th 05 08:50 PM
DATE Functions??? malay_ko Excel Programming 2 May 5th 04 09:51 AM


All times are GMT +1. The time now is 10:36 AM.

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

About Us

"It's about Microsoft Excel"