# Workday formula not skipping weekend

1. ## Workday formula not skipping weekend

The Workday formula was working great until D23 where it failed to skip the weekend. It is the same formula for the entire column D, can't figure out why it stopped working.

Thanks in advance for the help!

Dale

2. ## Re: Workday formula not skipping weekend

What is wrong? What results are you expecting?

3. ## Re: Workday formula not skipping weekend

The formula is in every cell of Column D. D23 returns a Saturday date. D2:D22 skipped the weekends as it is supposed to.

4. ## Re: Workday formula not skipping weekend

Sorry - I realise that now and have changed my questions. Please tell us (a) which results are wrong and (b) what you expect the formula to return.

5. ## Re: Workday formula not skipping weekend

Originally Posted by rdd2
D23 returns a Saturday date. D2:D22 skipped the weekends as it is supposed to.
I need column D to calculate column C plus column B, using only working hours and work days.

6. ## Re: Workday formula not skipping weekend

OK - so what results are you expecting to see in the cells that you asy are not calculating correctly? Don't leave us to work it out ourselves, please - just tell us so that we know what we are working towards. Thanks.

7. ## Re: Workday formula not skipping weekend

Sorry.

C23 "4/12 10:50 a" + B23 "7" hours = "4/13 8:50 a"

4/13 is a Saturday and should not be counted. D23 should equal "4/15 8:50 a" which is a Monday.

8. ## Re: Workday formula not skipping weekend

Working hours are 7:00a to 4:00p, Monday through Friday. They are referenced on the 'Info' sheet.

9. ## Re: Workday formula not skipping weekend

Thanks for the clarification.

10. ## Re: Workday formula not skipping weekend

D2
=IF(B2="","",MOD(C2+MOD(IF(E2>0,E2,B2),9)/24,1)-"9:00"*(MOD(C2+MOD(IF(E2>0,E2,B2),9)/24,1)-"16:00">0)+WORKDAY(C2,(MOD(C2+MOD(IF(E2>0,E2,B2),9)/24,1)-"16:00">0)+INT(IF(E2>0,E2,B2)/9),Info!\$A\$2:\$A\$26))

11. ## Re: Workday formula not skipping weekend

That seems to work on Excel, but this workbook is used on Google sheets. This is the error message I get when using the above formula on Google sheets...

"Function MOD parameter 1 expects number values. But 'ACTUAL' is a text and cannot be coerced to a number."

12. ## Re: Workday formula not skipping weekend

Nowhere until now did you mention this was not for Excel ...

I have moved the thread to the correct section.

14. ## Re: Workday formula not skipping weekend

Thank you Bo!

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1