I'm creating a template for customers to fill out and need to display their age when given their date of birth. I'm using the formula =DATEDIF(A1,TODAY(),"y") and it's working fine, but I I want to leave cells blank if no date of birth is provided. For example, there are cells to fill in up to six children, if they only have two I want 3 through 6 to remain blank. Any suggestions?
Hello,
you can wrap the formula in an IF statement. Assuming that the birthday of the child is entered in cell A1, use
=if(isnumber(A1),DATEDIF(A1,TODAY(),"y"),"")
The formula will only calculate the age if A1 contains a number (a date is a number in Excel).
cheers, teylyn
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks