Business Days Or Working Days

[Date-less]

Here's the problem. I receive a list of daily prices
that I need to compare to an index. Many of my daily
prices are effective at 6:00 after the markets have
closed. Therefore, I need to show them in my analysis as
the next BUSINESS DAY. How can I get around weekends and
holidays? I have some work arounds, but I would prefer a
standard function if that is possible.

 

[Frank Kabel]

Hi
if A1 is the starting date and you want to get the next business day
use
=WORKDAY(A1,1)

Notes:
- you have to install the Analysis toolpak Add-in for this.
- you can also include holidays in this formula:
=WORKDAY(A1,1,list_of_holidays)