Business Days Or Working Days

  • Thread starter Thread starter Date-less
  • Start date Start date
D

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.
 
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)
 
Back
Top