#1
|
|||
|
|||
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 |
#2
|
||||
|
||||
Try
Code:
=DATEDIF(...)*(E10<>"") |
#3
|
|||
|
|||
=IF(E10="", "", DATEDIF(E10,TODAY(),"y"))
|
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
PDF Conversion Issue - Background Tiled Image Size Issue | dustpie | Word | 1 | 10-23-2016 07:33 PM |
Is this a PowerPoint issue or a Mac issue? | Brian_V | PowerPoint | 0 | 05-14-2015 09:19 AM |
Using DateDif Function | OTPM | Project | 5 | 03-17-2014 05:16 AM |
Help with DATEDIF Formula | caz46 | Excel | 7 | 01-12-2012 08:46 AM |
New Issue | jantoine | Outlook | 1 | 09-28-2010 06:08 PM |