Thread: DATEDIF issue
View Single Post
 
Old 11-12-2021, 05:10 AM
teza2k06 teza2k06 is offline Windows 10 Office 2010 32bit
Advanced Beginner
 
Join Date: Feb 2013
Posts: 37
teza2k06 is on a distinguished road
Default 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
Reply With Quote