Detectiveclem
Active Member
- Joined
- May 31, 2014
- Messages
- 320
- Office Version
- 365
- 2016
- Platform
- Windows
- MacOS
Hi I wondered if anyone can assist me with the following; when I use the formula below everything works perfectly so long as there is data in the cell in column P
=DATEDIF(P2,TODAY(),"Y")
However when the referenced cell in column P is blank it always returns a value of 120. I understand to some extent why this is happening as it is assuming the blank cell is 1900.
How do I amend the formula to leave the cell wher I have placed the formula blank if the referenced cell in column P is blank?
Thank you to those who can assist.
=DATEDIF(P2,TODAY(),"Y")
However when the referenced cell in column P is blank it always returns a value of 120. I understand to some extent why this is happening as it is assuming the blank cell is 1900.
How do I amend the formula to leave the cell wher I have placed the formula blank if the referenced cell in column P is blank?
Thank you to those who can assist.