Formula error when trying to generate value based off of between dates

JenLinds

I'm using this formula but I'm getting an #INVALID OPERATION error.

=IF(AND(date@row >= [Start Date]@row, date@row <= [End Date]@row), "yes", "no")

I used the Smartsheet formula creator to create my formula and all of my date rows are formatted to use dates what am I doing wrong?

Cory Page

I set this up below and everything seems to be working, is there anything different with your columns other than names compared to my example? I have locked in the Date format as well,

=IF(AND([Completion Date]@row >= [Start Date]@row, [Completion Date]@row <= [End Date]@row), "Yes", "no")

JenLinds

Hi Cory and thanks for helping- it matches up however the start and end date are formulas rather than static data entries.

Paul Newcome

What are the formulas you are using to populate the dates?