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

Highlight Duplicates
Home, Conditional Formatting, Highlight Cells, Duplicate records, OK to add pink formatting to any duplicates in selected range.

Joe4

MrExcel MVP, Junior Admin
Joined
Aug 1, 2002
Messages
58,378
Office Version
  1. 365
Platform
  1. Windows
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.
 

plettieri

Well-known Member
Joined
Sep 4, 2002
Messages
1,556
Platform
  1. MacOS
Hi:


Holidays may be a bit different (counties may vary).

plettieri
 

Joe4

MrExcel MVP, Junior Admin
Joined
Aug 1, 2002
Messages
58,378
Office Version
  1. 365
Platform
  1. Windows
You have to set your own holiday list. It doesn't assume any for you.
 

Forum statistics

Threads
1,136,994
Messages
5,679,030
Members
419,800
Latest member
spvsr999

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
Top