Count number of working days between two dates

**dmucciolo** · 10-01-2012, 01:47 PM

Hi,

I'm trying to figure out how to calculate how many working days are in between two dates (currently, the formula i'm using only counts the total number of days).

Ex:

A1 B1 =B1-A1
1/30/2012 4/18/2012 79

thanks!

Debbie

**ConneXionLost** · 10-01-2012, 02:13 PM

Hi Debbie,

Try this:

Please Login or Register  to view this content.

**[email protected]** · 10-03-2012, 12:29 AM

Hi,

Kindly help, i need to count number of working days excluding holidays. Another problem is some end dates are still missing, thus i want to reflect result(those without end date) as "pending completion". please advise thanks so much.

**vlady** · 10-03-2012, 02:22 AM

Welcome to the forum myswims22, unfortunately:

Your post does not comply with Rule 2 of our Forum RULES. Don't post a question in the thread of another member -- start your own thread. If you feel it's particularly relevant, provide a link to the other thread. It makes sense to have a new thread for your question because a thread with numerous replies can be off putting & difficult to pick out relevant replies.