Formula for calculating remaining weeks

brhea110891

I have planned start and planned finish dates for projects. I want to calculate/share the weeks or days remaining on a project, and if this is a negative number, meaning we have gone past the planned finish, show this. Suggestions?

Thank you,

Becky

Peggy Parchert

Hello @brhea110891

Hope you are well. We use this formula for Working Days until Go-Live

=NETDAYS([TODAY Helper]23, [Planned Start Date]23)

Planned Start is the beginning of the project

TODAY Helper is a helper column that I use to automate the updating of the TODAY().

NETDAYS returns the number of days between two days.

Hope this helps!

Peggy

brhea110891

Thank you, Peggy,

That is very helpful and gets me halfway to where I'd like to go.

I also learned that I can use NETWORKDAYS

Now, what I would like to do is translate the number of NETDAYS days into number of weeks.

Thank you.

Becky