Capture.PNG
says to determine the person's age as an integer and not a decimal with a formula (Cell B4)
Capture.PNG
says to determine the person's age as an integer and not a decimal with a formula (Cell B4)
hi rainydai, welcome to the forum. there's this formula called DATEDIF you can use. it is without the screen tip all other formulas have though. so if your Date Of Birth is in B4 and the cut-off date is today, then:
=DATEDIF(B4,TODAY(),"y")
this will change everyday. if you want a fixed cutoff date, maybe something like:
=DATEDIF(B4,--"1Jan2013","y")
Thanks, if you have clicked on the * and added our rep.
If you're satisfied with the answer, click Thread Tools above your first post, select "Mark your thread as Solved".
"Contentment is not the fulfillment of what you want, but the realization of what you already have."
Tips & Tutorials I Compiled | How to Get Quick & Good Answers
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks