Formal to show days remaining in a timeline

Does anyone have a formula that shows the days remaining for the project timeline coloumn? I’d like to add a column that shows how many days are remaining in a project timeline so I can see how close we are till moving to the next phase.

Thanks in advance,
Michael

Hi @MLyons, you can use the following:
ROUND(DAYS({Timeline#End},TODAY()),0)

If you want to exclude weekends:
ROUND(WORKDAYS({Timeline#End},TODAY()),0)

Hope this helps!
Mark

Checking one thing, and asking one thing:

  • Above syntax still good in 2025?
  • Any way to exclude national holidays as well?