I want to calculate the age of a person on their next birthday date.
I attached a sample.
Regards,
Sanjeevi
I want to calculate the age of a person on their next birthday date.
I attached a sample.
Regards,
Sanjeevi
Last edited by sanjeevi888; 08-11-2012 at 01:17 PM.
This formula will give the next birthday
=EDATE(C3,DATEDIF(C3,TODAY(),"y")*12+12)
if you just want age at next birthday try
=DATEDIF(C3,TODAY(),"y")+1
Audere est facere
Thank... daddylonglegs
=EDATE(C3,DATEDIF(C3,TODAY(),"y")*12+12)
code woking
Thank U very much
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks