Formula to check a box depending on start & end date
I have 2 date columns (start date & end date) and 2 checkbox columns (live & concluded).
I want to have the checkboxes automatically check and uncheck depending on the dates. For example:
I have an event that runs from 12/2 through 12/4. On 12/2 I want the "Live" column checkbox to check and stay checked until the end of 12/4. From there, I want the "Live" checkbox to uncheck and the "Concluded" checkbox to check.
I've been playing around with formulas and cannot get it to work through a date range. I'm using conditional formatting to show active events on the calendar view and felt like this would be the best way to automate this.
Any ideas/is this possible/is there a better way?
Thank you so much in advance!
Help Article Resources
Check out the Formula Handbook template!