BUSINESS DAYS - Need function that will list next 3 business days.

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Jay CFA - 13 Feb 2007 05:29 GMT

This seems simple but I can't seem to figure out how to do it.

In a worksheet I have a cell into which today's date is entered automatically.
Using =Now()

I want excel to give me the next three business days (i.e. next 3 days
excluding holidays and weekends)

For example if today is Thursday 2/15, I want it to give me
Friday 2/16
Monday 2/19
Tuesday 2/20.

Any bright ideas?
Monday 2/

Reply to this Message

NickHK - 13 Feb 2007 05:40 GMT

How do you know the holidays ?
e.g. Monday & Tuesday are holidays for me in HK.

Weekday( ) can tell the day of the week.

NickHK

> This seems simple but I can't seem to figure out how to do it.
>
[quoted text clipped - 11 lines]
> Any bright ideas?
> Monday 2/

Reply to this Message

Robert - 13 Feb 2007 06:58 GMT

If your original date is A1 in B1 =WORKDAY(A1,1)
in B2 =WORKDAY(A1,2)
in B3 =WORKDAY(A1,3)

(from this ng)
--
Robert

> This seems simple but I can't seem to figure out how to do it.
>
[quoted text clipped - 11 lines]
> Any bright ideas?
> Monday 2/

Reply to this Message

Bob Phillips - 13 Feb 2007 09:19 GMT

Don't forget the holidays

=WORKDAY(A1,1,holidays)

where holidays is named range of holiday dates.

Signature

HTH

Bob Phillips

(there's no email, no snail mail, but somewhere should be gmail in my addy)

> If your original date is A1 in B1 =WORKDAY(A1,1)
> in B2 =WORKDAY(A1,2)
[quoted text clipped - 19 lines]
> > Any bright ideas?
> > Monday 2/

Reply to this Message