Dates in IFS Statement
I am trying to use dates (formatted in dates columns) in an IFS statement to compare dates in multiple columns and provide calculations based upon whether a date is before or after (<>) a certain date. I am getting an #UNPARSEABLE error message. I'm wondering if the dates are not reading correctly in the formula, or if something else is wrong. I copied the formula format from a preexisting Excel sheet.
Take a look: