LinkBack URL
About LinkBacks
Please assist!
As of this year, a person is 61 years old. I need a formula to determine in what year will they turn 65?
Number of years between to dates, with corresponding year qualifier
Please assist!
As of this year, a person is 61 years old. I need a formula to determine in what year will they turn 65?
"As of this year"
Do you mean they turned 61 this year or they turned 61 last year?
Unless you know that you wont be able to work out when they're 65.
It could be 3 years from now or possibly 4.
Regards
Special-K
Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.
I have the exact date of birth in the spreadsheet also so I can use that in the formula instead if the "61."
Example birthday is 10/19/1953
Without the aid of a spreadsheet they'll turn 65 in 10/19/2018.
Simple maths.
Dateofbirth + number of years
=DATE(YEAR(A1)+65,10,19)
Yes, I am aware of how to add manually. However, in this case I need a formula to do it for me.
There are too many entries to do it manually. I need to be able to drag it down, so entering the 10 and the 19 in the formula wouldn't quite do the trick.
Go on, give us a clue. Show us some data.
I don't know how to put part of a spreadsheet in here, but this is the idea:
First Name Last Name Date of Birth Current Age How Many Years Until 65? Date Turning 65?
John Doe 10/19/1953 61
The answers are easy to get to, they can be determined just by looking at them
Assuming there are 6 columns A-F
in E1
=65-(YEAR(TODAY())-YEAR(A1))
in F1
=DATE(YEAR(A1)+65,MONTH(A1),DAY(A1))
With birthday in B2:
65th birthday:
=EDATE($B$2,65*12)
Years untill 65:
=DATEDIF(TODAY(),EDATE($B$2,65*12),"y")
Quang PT
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks