Forum Discussion
CStroud1234
Mar 18, 2023Copper Contributor
Help with formula to calculate a future date
Hi,
I am trying to have cell Q2 look at cell D2 and then enter a date in Q2 that is 60 months after the date shown in D2. So I have this formula in Q2: =EDATE(D2,60)
The above formula is working correctly if a date is shown in D2 but my problem is that if no date is shown in D2, I want Q2 to not show a date but instead it is showing 12/31/04.
How can I get Q2 to not shown anything if D2 is blank?
Thank You.
2 Replies
Sort By
- OliverScheurichGold Contributor
- CStroud1234Copper Contributor
OliverScheurich Yes! That worked perfectly! Thank you!