MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Weekdays between two dates?


Posted by Helen on January 22, 2002 2:54 PM

I am trying to come up with a formula to count the number of days between two dates, excluding weekends. Can anyone help me out?


Posted by Mark W. on January 22, 2002 3:02 PM

Use the NETWORKDAYS() function which is only
available after the addition of the Analysis
ToolPak. For example, if A1 contains 1/1/01
and B1 contains 6/13/01 then =NETWORKDAYS(A1,B1)
return 118.

Posted by Steve Hartman on January 22, 2002 3:03 PM


Use =NETWORKDAYS function. You can find it by typing the = sign in the cell and following the function help to Date & time functions.

Posted by Joe Was on January 22, 2002 3:07 PM

This will do years months days for your birthday:

=IF(F6="","Please Enter Your Birthday Above!",DATEDIF(F6,NOW(),"y")&" years, "&DATEDIF(F6,NOW(),"ym")&" months and "&DATEDIF(F6,NOW(),"md")&" days")

F6 is the date location this formula is in another cell.

And,

=IF(OR(F13="",F16=""),"Add Both Dates Above!",DATEDIF(F13,F16,"y")&" years, "&DATEDIF(F13,F16,"ym")&" months and "&DATEDIF(F13,F16,"md")&" days")

F13 is the oldest date location and F16 is the newest date location, then this formula will give you the years months and day between the dates. Hope this gets you started. PS this uses the analysis addin! JSW

Posted by Helen on January 22, 2002 3:12 PM

Analysis ToolPak?

That's great ... it'll save me a lot of time, but how do I add analysis toolpak?

Thanks ...

Posted by Steve Hartman on January 22, 2002 3:14 PM

Re: Analysis ToolPak?

Tools Menu > AddIns > check the box for Analysis ToolPak

Posted by Helen on January 22, 2002 3:22 PM

Re: Analysis ToolPak?

Thank you so much! This is the first time I've used this site. I didn't expect such a great response!

Have a good evening ... :)