Formulas

Production Elapsed %

Production

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