Trying to check a box if 2 dates are within 14 days of eachother.

colbylomonaco

I tried this =IF([Datecolumn1]1 + 14 < [Datecolumn2], 1, 0)

but it just comes back as unparseable

Paul Newcome

Try removing the comma and space after "[Datecolumn2]".

colbylomonaco

That didnt work unfortunatley. When I am putting in the names of the columns, if there is a space I tried it with an underscore and without, and then with and without that comma also and it still comes back as unparseable

Paul Newcome

Are you able to provide a screenshot of the column names in question?

Paul H

Think your missing a 1 after [Datecolumn2]

=IF([Datecolumn1]1 + 14 < [Datecolumn2]1, 1, 0)