Work Day

[Jennifer Van]

I have this formula in my spreadsheet
=(IF(U3="","",IF((U3-T3)<4,"Yes","No")))
and it works really well but I can't work out how to add only workdays - no Sat Sun can everybody help me please?
Jennifer

 

[6StringJazzer]

The formula tells us nothing at all about what you are trying to do. No idea what you mean by "add only workdays" in this context. Are U3 and T3 dates, and you are trying to figure out if there are fewer than 4 work days between them?

Here is my best guess, but you really need a more complete description of your question.

=(IF(U3="","",IF(NETWORKDAYS(T3,U3)<4,"Yes","No")))

 

[Jennifer Van]

=(IF(U3="","",IF(NETWORKDAYS(T3,U3)<4,"Yes","No")))

Sorry will do better next time, but yes you are correct I have two dates; in cell T is the due date and cell U is the date a call should take place. Cell W is where I have the formula which asks if the call took place with 4 working days of when it was scheduled.

I copied your formula but it just stays in the cell W3 and in the formula bar - and show an error see below
I hope this is clearer
Thanks
Jen

 

[6StringJazzer]

Is this a table? If so you should be using structured references.

There is nothing wrong with the formula. That is not really an error, it's a warning suggesting maybe you didn't intend to do what you are doing. It means this formula is different than other formulas in the same column.
It would help if you showed the whole table including row and column headers.

 

[Jennifer Van]

Is this a table? If so you should be using structured references.

There is nothing wrong with the formula. That is not really an error, it's a warning suggesting maybe you didn't intend to do what you are doing. It means this formula is different than other formulas in the same column.
It would help if you showed the whole table including row and column headers.

Is this a table? If so you should be using structured references.

There is nothing wrong with the formula. That is not really an error, it's a warning suggesting maybe you didn't intend to do what you are doing. It means this formula is different than other formulas in the same column.
It would help if you showed the whole table including row and column headers.

Thanks - I cleared the whole column and reinserted your formula and it worked so thank you
Jen

 

[smozgur]

Thanks - I cleared the whole column and reinserted your formula and it worked so thank you

The marked solution post has been changed accordingly.

@Jennifer Van: In your future questions, please mark the post as the solution that answered your question as it will help future readers. No further action is required in this thread.