Forum Discussion

CStroud1234's avatar
CStroud1234
Copper Contributor
Mar 18, 2023
Solved

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.

Resources