Help with a date formula.

Michael Lasonde

I would like to enter in a date into the end date column (its currently enabled as a date column) however the formula listed below returns an error of #DATE EXPECTED. The false value "-" shows up but the date does not. Any help on this would be greatly appreciated.

Here is my logic written out.

if rotation # column = 1 then enter the date 05/08/2021 into end date column. Im missing something but I cannot see it.

=IF([Rotation #]@row = "1", [End Date]@row = DATE(2022, 5, 8), "-")

Kelly Moore

Oh wait, I didn't even notice the row reference-you wouldn't need the [End Date]@row reference- it would only be the date as the true statement.

=IF([Rotation #]@row = 1, DATE(2022, 5, 8), "-")

Kelly Moore

Hey @Michael Lasonde

Your [Rotation #] appears to be a number but the quotes around the "1" is forcing it to behave as text. Remove the quote marks from 1

cheers

Kelly

Michael Lasonde

Hi KDM, I appreciate the reply however after removing the "" I still have the same results.

Kelly Moore

Oh wait, I didn't even notice the row reference-you wouldn't need the [End Date]@row reference- it would only be the date as the true statement.

=IF([Rotation #]@row = 1, DATE(2022, 5, 8), "-")

Michael Lasonde

Thats it right their, Thank you KDM