Thread: date of birth or blank cell?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Jacob Skaria Jacob Skaria is offline
external usenet poster
  
Posts: 8,520
Default date of birth or blank cell?
With DOB in cell A1 try the below

=IF(A1="","No DOB",DATEDIF(A1,TODAY(),"y")&" years")

--
Jacob


"KrisP" wrote:

Hello,
this may sound simple, but i have a date of birth in one cell, I want to
show the age or a blank cell if empty (no dob) next to it. What formula
would i use?
Many thanks in advance!
K
Reply With QuoteReply With Quote