I want to calculate the age of a person on their next birthday. I attached a sample.
I appreciate any help.
Thanks,
Nick
I want to calculate the age of a person on their next birthday. I attached a sample.
I appreciate any help.
Thanks,
Nick
Hello,
Maybe something like this:
abousettaPlease Login or Register to view this content.
Hello,
maybe
=IF(DATE(YEAR(TODAY()),MONTH(C3),DAY(C3))<TODAY(),YEAR(TODAY())+1-YEAR(C3),YEAR(TODAY())-YEAR(C3))
Depending on how you want to handle the situation when today = the birth day, then you may want to change the first < to <=
cheers,
This maybe a better approximation from my previous post:
abousettaPlease Login or Register to view this content.
@abousetta, if my next birthday is next month, your first formula makes me one year older than I am and the second formula makes me one year younger.
There must be something more elegant but this seems to work
Please Login or Register to view this content.
Thanks for the help. I will test those out.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks