Check box if date is equal to or between dates

mhint2005

I want to create a formula to do the following:

If the "Created Date" is equal to OR between the "Week Start" and "Week End" dates, I want to check the "Submitted on Time" box.

I tried =IF([Created Date]@row, >=[Week Start]@row, <=[Week End]@row, 1, 0) and am getting an INCORRECTARGUMENT error. I'm sure I'm missing something easy but I'm blaming it on a case of the Mondays.

Thanks in advance!

Brian Wilson DC

@mhint2005 Good afternoon! Your formula needs an AND statement so it captures both of the ranges you want it to fall in. Below is a screenshot of the formula working (I put five dates to show it not being submitted on-time outside of your range, and it being submitted on time on the first day, last day and a middle day of your range. The formula I used is posted below:

=IF(AND([Created Date]@row >= [Week Start]@row, [Created Date]@row <= [Week End]@row), 1, 0)

I hope this helps!

Regards,

Brian

Paul Newcome

You need an AND statement.

=IF(AND([Created Date]@row >= [Week Start]@row, [Created Date]@row <= [Week End]@row), 1)

Brian Wilson DC

@mhint2005 Good afternoon! Your formula needs an AND statement so it captures both of the ranges you want it to fall in. Below is a screenshot of the formula working (I put five dates to show it not being submitted on-time outside of your range, and it being submitted on time on the first day, last day and a middle day of your range. The formula I used is posted below:

=IF(AND([Created Date]@row >= [Week Start]@row, [Created Date]@row <= [Week End]@row), 1, 0)

I hope this helps!

Regards,

Brian

mhint2005

Thank you, Paul and Brian, for the quick response! Super helpful.

Paul Newcome

Happy to help. 👍️