Hi
I am trying to create a metric for a Sight sheet to show countdown in days and another in weeks until a project starts
can anyone help ?
Cheers
Neil
=Date23 - TODAY()
will show how many days are left before the value in the Date column, row 23.
If you want to stop at 0 on your countdown (negative is past-due) then
=MAX(Date23 - TODAY(),0)
To get weeks, divide by 7.
If you want an integer number of weeks, look at using ROUND or INT.
I hope this helps.
Craig
