Forum Discussion

BarbO404717's avatar
BarbO404717
Copper Contributor
Aug 19, 2022
Solved

EDATE WITH CONDITIONS

Need help with this type of formula:   If M21 (a date cell) is blank, then evaluate D21 (length of stay).  If D21 (length of stay) is less than or equal to 730, then add 6 months to C21(admit date)...
Formulas and Functions
  • SergeiBaklan's avatar
    SergeiBaklan
    Aug 19, 2022

    BarbO404717 

    Literally

    =IF( M21="",
     EDATE( C21, 6 + 6*(D21>730) ),
     EDATE( M21, 6 + 6*(D21>730) )
)
BarbO404717's avatar
BarbO404717
Copper Contributor
Aug 19, 2022
Thanks Sergei. Does your formula cover both scenarios regarding cell M21?
Barb
SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
Aug 19, 2022

BarbO404717 

I hope so. M21 is blank or not. In first case we calculate with C21, otherwise with M21. Same formula.

However, I didn't test it.

Resources