Date Calculation for Formula Checkbox field
I am trying to build out a To-Do app, and I want to sort by Tasks that have a due date within 7 days of the current date. My idea was to create a Formula-Checkbox field with an if/then statement that...
Forum Discussion
Here is a formula
IF(Today()-[Due Date] <= Days(7), "Due within 7 Days", "Not Due within 7 Days")
IF(Today()-[Due Date] <= Days(7), "Due within 7 Days", "Not Due within 7 Days")