DATEDIF issue
Hi All,
I currently have a spreadsheet that calculates how old someone will be from their date of birth, as of 31/08/2022. However while the date of birth field is empty, it automatically defaults the age as of 31/08 field to 122.
Is there a way that while the date of birth field (E10) is empty, then age as of (F10) will show as 0 or just be blank?
My DATEDIF formula for the "Age as of" is in F10.
Many Thanks
|