In Excel formula to calculate the date someone will hit 65

G

gls858

sgwill said:
Using a formula, calculate from birthdate what date a person will turn 65.
Click to expand...

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

gls858
 
D

Dave Peterson

Except for February 29th issues:

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Display weeks from a Milestone 0
Are they 65 yet? 3
Calculate elapsed time excluding specific timeframe 10
Enable Iterative Calculations 0
Help with Calculating Dates 1
Convert number to date 1
MS Word Merge fields 0
calculating age in excel 0

Top