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

Theo Seale

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

Frank S.

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.

Theo Seale

Hi Frank.

Thank you, your formula is working perfectly.

Frank S.

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.

Theo Seale

Hi Frank.

Thank you, your formula is working perfectly.

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.

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