Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Date formulas | Excel Discussion (Misc queries) | |||
Excel formula where I can add business days (date) | Excel Discussion (Misc queries) | |||
formula to calculate age using birth date and current date | Excel Worksheet Functions | |||
Imported Date & Time format with calcs. managed in excel from imrp | Excel Worksheet Functions | |||
Excel running date formula minus weekend days | Excel Worksheet Functions |