how to figure days while omitting weekend & holidays

berbes

New Member
Joined
Dec 9, 2004
Messages
31
hello all!

i have one cell that shows the date when something was sent out (let's call it A1), and one cell that shows the date it was received back (let's call it B1). i need a formula that shows how many BUSINESS days went by, not counting holidays and weekends.

can someone show me a formula that'll show this?

thanks!!!!!!!!!
jackie
 

Excel Facts

When they said...
When they said you are going to "Excel at life", they meant you "will be doing Excel your whole life".
Check out the NETWORKDAYS function in Excel help.

Please note this part from Help, too:
If this function is not available, run the Setup program to install the Analysis ToolPak. After you install the Analysis ToolPak, you must enable it by using the Add-Ins command on the Tools menu.
 
Upvote 0
You have to set your own holiday list. It doesn't assume any for you.
 
Upvote 0

Forum statistics

Threads
1,217,753
Messages
6,138,417
Members
450,136
Latest member
Tabako1960

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top