How would you calculate the difference between work days with a 4 day week
AND holidays??

thanks
--
AJ

With difficulty based on this question!

Could you please give a specific example please of what you are trying to
"difference"?

"AJ" wrote:

How would you calculate the difference between work days with a 4 day week
AND holidays??

thanks
--
AJ

I have some formulas at
http://www.cpearson.com/Excel/BetterNetWorkDays.aspx that show how to
get the number of days between two dates, excluding any number of days
of the week and specified holidays. It is a replacement for the
NETWORKDAYS function, in which Saturday and Sunday are hard wired in
the function.

Cordially,
Chip Pearson
Microsoft Most Valuable Professional,
Excel, 1998 - 2010
Pearson Software Consulting, LLC
www.cpearson.com




On Thu, 18 Mar 2010 18:24:01 -0700, AJ
wrote:

How would you calculate the difference between work days with a 4 day week
AND holidays??

thanks