I am trying to calculate a person's age today (in H2) by entering their date of birth (in G2), however all blank DOB cells produce a number in the targeted cell.
Can somebody please help me convert this formula to display a blank cell if no date is entered?
=DATEDIF(G2,NOW(),"y")
Thanks!
Bookmarks