Subtracting Dates between 2 cells - #INVALID OPERATION

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


Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!