Sign in to join the conversation:
The posts in this section are historical and no longer monitored for accuracy. If this discussion interests you and you'd like to join in, please visit the active Community to post and engage.
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
