PLEASE..... don't use DAYS360. It's intended for financial calculations. It
will, for example, tell you that the number of days between 2/1/2005 and
3/1/2005 is 30 instead of 28.
I think this formula will work. Start date is in A1, end date is in B1, and
named range Holidays has the list of holidays to be removed.
=B1-A1-(COUNTIF(Holidays,"="&A1)-COUNTIF(Holidays,""&B1))
On Wed, 2 Mar 2005 14:53:03 -0800, "Jack"
wrote:
there is no formula that will exclude holidays, the Days360 function will
calculate the number of days between 2 dates. Example:
=Days360("1/1/2005","1/15/2005") = 14
-Jack
"abs2299" wrote:
I am wondering if there is a formula out there that will calculate the
number
of days between two dates, but exlclude holidays. I know there is a
formula
that will calculate work days, but I need one to calculate all days of the
week, not just work days.
|