Detectiveclem
Active Member
- Joined
- May 31, 2014
- Messages
- 320
- Office Version
- 365
- 2016
- Platform
- Windows
- MacOS
Help please, I am using the following formula which works perfectly when someone enters their actual date of birth in cell D18, but until they do I want the text as shown below to show in cell D18, but do not want the error code shown to appear. I would prefer it remained blank or said "Auto Polulated".
I have tried playing with IFERROR but can't find the correct way to write the formula. Any help would be greatly appreciated.
=IF(D18>0,DATEDIF(D18,TODAY(),"Y"),"")
I have tried playing with IFERROR but can't find the correct way to write the formula. Any help would be greatly appreciated.
=IF(D18>0,DATEDIF(D18,TODAY(),"Y"),"")