LinkBack URL
About LinkBacks
Calculating age using current date less birthdate. Current formula is returning 111 for age if no birthdate is entered.
See attached sample. Formula used is =DATEDIF(C13,$D$3,"Y")
Help is appreciated!
Formula to return zero if date missing
Calculating age using current date less birthdate. Current formula is returning 111 for age if no birthdate is entered.
See attached sample. Formula used is =DATEDIF(C13,$D$3,"Y")
Help is appreciated!
Last edited by katweller; 09-15-2011 at 04:43 PM.
Hello katweller,
try this version
=IF(C10="","",DATEDIF(C10,$D$3,"y"))
Audere est facere
Perfect! Thank you!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks