4 day work week

A

AJ

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

thanks
 
M

Matt Geare

With difficulty based on this question!

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

Chip Pearson

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Calculate Net Work Days for 4 day weeks 4
[newbie] first day of week 3
EXCEL 2003 7 Day Week plus Holidays 1
If and Vlookup formula 1
Calculate Transaction Time Over Days 3
Does networkdays have a six day week? 1
Which Formula to use 1
day of the week and date formula 2

Top