IF todays date is between start date and end date then check this box

kjsneaks

I need to run an active projects report that collects data on in progress projects. I need to put the formula into the checklist column so that it checks it if todays date is between the start and end date.

Mike Wilday

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

Try adding this formula and dragging down through the rows. 

Paul Newcome

You can also add in your In Progress criteria within the AND function.

 

=IF(AND(Today()<[End Date]@row, Today()>[Start Date]@row, Status@row = "In Progress"),1, 0)

kjsneaks

Thank you for your answer it helped but is there a way to have it include the jobs started today. If the job is 1 day long to complete it wont be checked.

 

Paul Newcome

Try changing

 

TODAY() > [Start Date]@row

 

to

 

TODAY() >= [Start Date]@row

 

The same can be done with the End Date as well.

kjsneaks

thank you!

Paul Newcome

Happy to help!