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) )
)
SergeiBaklan's avatar
SergeiBaklan
MVP
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
OMG! It worked! Thank you so much. Is there any chance you can describe what you did in prose/text? Thanks, Barb
  • SergeiBaklan's avatar
    SergeiBaklan
    MVP
    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's avatar
      BarbO404717
      Copper Contributor
      Aug 19, 2022
      Thank you!!

Resources