1

I have been going around and around but haven't quite grasped some of the key formula concepts.

I have a start date and want to add 5 business days to it. Start date + 5 doesn't take into account that one or two of those days may be a weekend.

How would you set that up?

  • Use the weekday function and test the days to see if they are workdays or not... may need an if() or and() - have not thought about it yet... – Solar Mike Mar 16 at 19:32
  • I have thought conceptually about adding the 5 days one at a time, then testing to see if it the result was a Saturday. If it was, add an extra two days. But it is inelegant and will probably pull an error. I think there is probably an elegant solution. I am just not a math/code wiz enough to figure it out! – Matt McKee Mar 17 at 23:03
3

Days and dates are always messy, so whenever possible, one should try to use someone else's hard work. In this case, Apple have done it for us.

Say your date is in B2, example forumla to add five business days:
WORKDAY(B2,5,)

You can read more about its usage and find the other date-related functions available in Apple's Numbers Functions Reference.

  • And the same function exists in excel.... plus 1 from me. – Solar Mike Mar 19 at 15:49
  • Workday did the trick! Thank you. – Matt McKee Mar 20 at 16:54

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .