ExcelBanter - Formula to count days

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Formula to count days (https://www.excelbanter.com/excel-discussion-misc-queries/92467-formula-count-days.html)

ELS

Formula to count days

Hi, Please help!
I'm trying to do a formula to count the number of business days (i.e.
Mon-Fri) between two dates that i have in Excel.

i tried the formula "=DAYS360(B2,C2, FALSE)" but this gives the total
number of days, not just work days. (i used this where B2=4-Apr-06 and C2 =
18-Apr-06.)

Does anyone know how i can calculate the number of work days?

Thank you!!!!!!!!!!!!!!!!!1
--
ELS

Chip Pearson

Formula to count days

See the NETWORKDAYS function. It will take into account holidays
as well, if you provide it with a list of holidays. See help for
details.

--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

"ELS" wrote in message
...
Hi, Please help!
I'm trying to do a formula to count the number of business days
(i.e.
Mon-Fri) between two dates that i have in Excel.

i tried the formula "=DAYS360(B2,C2, FALSE)" but this gives
the total
number of days, not just work days. (i used this where
B2=4-Apr-06 and C2 =
18-Apr-06.)

Does anyone know how i can calculate the number of work days?

Thank you!!!!!!!!!!!!!!!!!1
--
ELS

Bondi

Formula to count days

Hi Els,

You could try to use the NetWorkDays()

It is in the Analysis ToolPak add-in

Regards,
Bondi

ELS

Formula to count days

Awesome! Thank you so much, Bondi!!!
--
ELS

"Bondi" wrote:

Hi Els,

You could try to use the NetWorkDays()

It is in the Analysis ToolPak add-in

Regards,
Bondi

ELS

Formula to count days

It worked!! Thank you, Chip!!!!
--
ELS

"Chip Pearson" wrote:

See the NETWORKDAYS function. It will take into account holidays
as well, if you provide it with a list of holidays. See help for
details.

--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

"ELS" wrote in message
...
Hi, Please help!
I'm trying to do a formula to count the number of business days
(i.e.
Mon-Fri) between two dates that i have in Excel.

i tried the formula "=DAYS360(B2,C2, FALSE)" but this gives
the total
number of days, not just work days. (i used this where
B2=4-Apr-06 and C2 =
18-Apr-06.)

Does anyone know how i can calculate the number of work days?

Thank you!!!!!!!!!!!!!!!!!1
--
ELS

All times are GMT +1. The time now is 05:16 PM.