Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old September 6th 06, 09:03 PM posted to microsoft.public.excel.newusers
external usenet poster
 
First recorded activity by ExcelBanter: Sep 2006
Posts: 2
Default In Excel formula to calculate the date someone will hit 65

Using a formula, calculate from birthdate what date a person will turn 65.

  #2   Report Post  
Old September 6th 06, 09:12 PM posted to microsoft.public.excel.newusers
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 209
Default In Excel formula to calculate the date someone will hit 65

sgwill wrote:
Using a formula, calculate from birthdate what date a person will turn 65.


Sounds like homework to me. I'll give you a hint.
Google on "calculate age in Excel" no quotes.

gls858

  #3   Report Post  
Old September 6th 06, 11:22 PM posted to microsoft.public.excel.newusers
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 35,218
Default In Excel formula to calculate the date someone will hit 65

Except for February 29th issues:

With the birthdate in A1:
=date(year(a1)+65,month(a1),day(a1))



sgwill wrote:

Using a formula, calculate from birthdate what date a person will turn 65.


--

Dave Peterson
  #4   Report Post  
Old September 7th 06, 01:56 AM posted to microsoft.public.excel.newusers
external usenet poster
 
First recorded activity by ExcelBanter: Sep 2006
Posts: 2
Default In Excel formula to calculate the date someone will hit 65

Perfect, thank you!!

"Dave Peterson" wrote:

Except for February 29th issues:

With the birthdate in A1:
=date(year(a1)+65,month(a1),day(a1))



sgwill wrote:

Using a formula, calculate from birthdate what date a person will turn 65.


--

Dave Peterson



Reply
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 formulas DRondeau Excel Discussion (Misc queries) 7 September 6th 06 09:53 PM
Excel formula where I can add business days (date) kskaug1 Excel Discussion (Misc queries) 3 September 1st 06 07:59 PM
formula to calculate age using birth date and current date lalah Excel Worksheet Functions 2 November 20th 05 10:51 PM
Imported Date & Time format with calcs. managed in excel from imrp Todd F. Excel Worksheet Functions 0 July 8th 05 09:03 PM
Excel running date formula minus weekend days Eliane Excel Worksheet Functions 2 March 30th 05 10:37 PM


All times are GMT +1. The time now is 03:50 AM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017