Calculate Business Days Between Two Variable Dates
In problem solving a scenario I found the need to calculate the number of business days between two variable dates. This turns out to be...
Calculate the Next Occurrence of a Date (After Today)
If you have an event, task, bill or subscription that happens on a weekly, monthly or yearly recurring cycle, here is a formula that will...
If “Today” is Within Date Range
I have found it immensely useful to be able to calculate if today’s date falls within a specific date range. For example, when using sprints...
Calculate Relative Date From a Standard Date Property
Being able to see a date relative to today can be super useful, not just to visualize how much time is left for a task,...