Skip to content
Calculate Due Dates
An easy way to set notifications related to due dates
This template is based on the solution I provided in the community.
Below you see the table I showed and the related code.
Base Table
Name
Date
Type
IntervalMonth
step05
Next LP date: 11/11/2026
11/11/2022
LP
24
11/11/2026
Next LCC date: not applicaple
10/8/2022
LCC
0
Next Corp date: 8/15/2025
8/15/2022
Corp
12
8/15/2025
There are no rows in this table
Sequence(1,20).ForEach(Product(CurrentValue,thisRow.IntervalMonth).WithName(intervals,
intervals.ForEach(
Date(
thisRow.Date.Year(),
thisRow.Date.Month() + CurrentValue,
thisRow.Date.Day()))
) - ToDay()).WithName(outcome,
Today() + outcome.Filter(CurrentValue > 1).First()).IfBlank("")
Want to print your doc?
This is not the way.
This is not the way.
Try clicking the ⋯ next to your doc name or using a keyboard shortcut (
CtrlP
) instead.