how do I report an error in the workday function in NUMBERS

Question

AlanS1952 Author

Level 1

8 points

how do I report an error in the workday function in NUMBERS

MacBook Pro 13″, macOS 11.4

Posted on Jun 1, 2021 8:33 AM

Reply

Answer 1

Top-ranking reply

SGIII

Level 8

37,556 points

Jun 1, 2021 9:53 AM in response to AlanS1952

Yes, it does look as if it's a bug. Here are the results in Excel:

Unless someone posts with different results, I suggest reporting via Numbers > Provide Numbers Feedback and choosing bug from the dropdown.

SG

Reply

Answer 2

SGIII

Level 8

37,556 points

Jun 1, 2021 8:48 AM in response to AlanS1952

You can give feedback to Apple via Numbers > Provide Numbers Feedback in your menu.

However, perhaps you could first post here with details on what error you see in the function.

SG

Reply

Answer 3

AlanS1952 Author

Level 1

8 points

Jun 1, 2021 9:30 AM in response to SGIII

I have a table of Bank Holidays and in order to work out the next working day for any particular date I use the WORKDAY function. It appears that when the date in question is a Bank Holiday date which is an EXCLUDED date within the Bank Holidays table then the next working day and the last working day jump a day. Here is a screenshot of the relevant part of the Bank Holiday table together with 4 tables showing how the dates change as one progresses through a particular weekend.

The numbers next to the dates in A1 are merely a stepper I use to adjust the date in A1.

The functions in the C columns is the syntax of the functions in the B columns.

You can see from the progression that when the current date (A1 value) moves on to the Bank Holiday Monday (3rd May) the last working day (-1) skips back to the Thursday and the next working day (+1) skips on to the Wednesday.

I can't see any logical reason why this could be considered correct.

Reply

Answer 4

Badunit

Level 7

30,588 points

Jun 1, 2021 8:08 PM in response to AlanS1952

Looks like a bug to me. It is certainly not the correct answer. It appears that if the date in the first parameter is an excluded date, it skips the next day as if it was also excluded. WORKDAY("5/6/21", 1, "5/6/21") should be Friday the 7th but the function says it is Monday the 10th. If May 6 and 7th are both exclude dates, the result is Tuesday the 11th when it should be Monday the 10th.

Reply