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 wor...
excel
Formulas and Functions
  • OliverScheurich's avatar
    OliverScheurich
    Mar 18, 2023

    CStroud1234 

    =IF(D2="","",EDATE(D2,60))

     

    Does this return the intended result if D2 is blank?

OliverScheurich's avatar
OliverScheurich
Gold Contributor
Mar 18, 2023

CStroud1234 

=IF(D2="","",EDATE(D2,60))

 

Does this return the intended result if D2 is blank?

Resources