Live progress of a plan based on calendar dates.
Expression
Elapsed_pct = clamp((now − Start) / (End − Start) × 100, 0, 100)Inputs
Start
date
End
date
now
timestamp
Output
Elapsed_pct
%
Worked Example
Start
2026-04-20
End
2026-05-09
now
2026-04-26
Result:~32% elapsed