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.

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)


--
Regards
Frank Kabel
Frankfurt, Germany


Date-less wrote:
> 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.