What would be the excel code for this: Todays date MM/DD/YYYY ( constantly changing ) - Birthdate MM/DD/YYYY = AGE in years ( Constantly updated )
Thank U!
What would be the excel code for this: Todays date MM/DD/YYYY ( constantly changing ) - Birthdate MM/DD/YYYY = AGE in years ( Constantly updated )
Thank U!
Last edited by CKD777; 10-14-2011 at 07:53 PM. Reason: Solved
If you have DOB in A1 try this formula in B1
=DATEDIF(A1,TODAY(),"y")
Audere est facere
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks