Formula for calculating remaining weeks

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,



  • Peggy Parchert
    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!


  • brhea110891
    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.