Forum Discussion

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

Aug 19, 2022

BarbO404717

Literally

=IF( M21="",
     EDATE( C21, 6 + 6*(D21>730) ),
     EDATE( M21, 6 + 6*(D21>730) )
)

SergeiBaklan

Diamond Contributor

Aug 19, 2022

BarbO404717

Literally

=IF( M21="",
     EDATE( C21, 6 + 6*(D21>730) ),
     EDATE( M21, 6 + 6*(D21>730) )
)

BarbO404717

Copper Contributor

Aug 19, 2022

OMG! It worked! Thank you so much. Is there any chance you can describe what you did in prose/text? Thanks, Barb

SergeiBaklan
Diamond Contributor
Aug 19, 2022
BarbO404717

Not sure I understood the question. We add to the date 6 months or 6+6 months depends on condition returns TRUE or FALSE, which are in arithmetic calculations equivalent to 1 and 0 accordingly.
- BarbO404717
  Copper Contributor
  Aug 19, 2022
  Thank you!!