Subtracting Dates between 2 cells - #INVALID OPERATION

Jeff Gordon

I am using the below formula to subtract 2 cells that contain dates. I have determined that the error is the the operation on the subtraction of the row date from a fixed / start date.

=IF(AND([Column18]8 = "Day 1", $[Column22]$6 - [Column14]8 > 0), 1, 0)

see pic

Bassam Khalil

Hi @Jeff Gordon 

Hope you are fine, please try the following

=IF(AND([Column18]8 = "Day 1", ($[Column22]$6 - [Column14]8 > 0), 1, 0))

Jeff Gordon

Hi @Bassam.M Khalil

Thank you for responding so quickly. I copied this into the field and I get the following error.

Thanks again for your help,

Jeff.

Bassam Khalil

@Jeff Gordon 

Please add a copy of your sheet or a screenshot (after removing or replacing any sensitive information). This will make it easier for me to provide the appropriate answer to your question.