LinkBack URL
About LinkBacks
I need a formula to calculate a person's age next birthday. I will have the date of birth in cell A1 and in A2 need a formula to calculate the age next birthday. I have attached a sample file.
Thanks in advance.
I need a formula to calculate a person's age next birthday. I will have the date of birth in cell A1 and in A2 need a formula to calculate the age next birthday. I have attached a sample file.
Thanks in advance.
Last edited by Aland2929; 05-31-2011 at 12:03 PM.
Try:
=DATEDIF(A1,TODAY(),"Y")+1
Dom
"May the fleas of a thousand camels infest the crotch of the person who screws up your day and may their arms be too short to scratch..."
Use code tags when posting your VBA code: [code] Your code here [/code]
Remember, saying thanks only takes a second or two. Click the little star to give some Rep if you think an answer deserves it.
Thank you very much. Works perfectly.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks