Create a Formula to count Working Days between a Due Date and Current Date

Hi There,

I have figured out the Formula NETWORKDAYS. It is doing what I ask,

BUT it if I drag the formula down it want to take the next row at Column - Today Date.

I tried putting a $ sign like you would do in Excel to lock the formula on the one cell. As shown below but it's not locking to the 1st Row at Column - Today Date.


Is there a formula that will automatically work on the Current Date. So I don't have to have a cell with Current date =[Today() ].

My object is to Calculate how many working days are between the Due Date Column and the current days.

Your help would be highly appreciated.

Regards Theo Seale

Tags:

Best Answers

  • Frank S.
    Frank S. ✭✭✭✭✭✭
    Answer ✓

    Theo,

    Try using the following

    =NETWORKDAYS([Test 1]@row, TODAY())

    That will calculate the number of days, always using today's date.

    I hope that helps.

    Frank Smith, PMP

    Assistant Director | IT Special Projects Mgr.

    Oregon Parks & Recreation Department

    If my response helps, please mark it as an accepted answer. 😎

  • Theo Seale
    Theo Seale ✭✭
    Answer ✓

    Hi Frank.


    Thank you, your formula is working perfectly.

Answers

  • Frank S.
    Frank S. ✭✭✭✭✭✭
    Answer ✓

    Theo,

    Try using the following

    =NETWORKDAYS([Test 1]@row, TODAY())

    That will calculate the number of days, always using today's date.

    I hope that helps.

    Frank Smith, PMP

    Assistant Director | IT Special Projects Mgr.

    Oregon Parks & Recreation Department

    If my response helps, please mark it as an accepted answer. 😎

  • Theo Seale
    Theo Seale ✭✭
    Answer ✓

    Hi Frank.


    Thank you, your formula is working perfectly.

  • Mimi H
    Mimi H ✭✭✭

    Does this work when the date you're using in the formula is not an @row cell but just a cell in the same column as the formula? I can't seem to get it to work. I am plugging in dates based on a list of items we have, all based on one date. I want to calculate working days, but I tried the formula listed earlier in this thread with no luck. Any ideas?


  • Genevieve P.
    Genevieve P. Employee Admin

    Hi @Mimi H

    Yes, you can reference a date earlier in the same Date column!

    The current formula you have is simply subtracting days from the Due Date in cell 3. If you're looking to subtract work days, try this function:

    WORKDAY Function

    E.g:

    =WORKDAY([Due Date]3, -45)

    Cheers,

    Genevieve

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!