ExcelBanter - Calculate Number of Days Between Dates Minus Weekends

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

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

- - Calculate Number of Days Between Dates Minus Weekends (https://www.excelbanter.com/excel-discussion-misc-queries/75531-calculate-number-days-between-dates-minus-weekends.html)

Melissa

Calculate Number of Days Between Dates Minus Weekends

I am trying to calculate the number of days between two given dates minus the
weekends. Is there a formula that does this?

Ron Rosenfeld

Calculate Number of Days Between Dates Minus Weekends

On Mon, 6 Mar 2006 10:49:30 -0800, Melissa
wrote:

I am trying to calculate the number of days between two given dates minus the
weekends. Is there a formula that does this?

Look in HELP for NETWORKDAYS. You will need to have the Analysis ToolPak
installed. The directions to do that are with the Networkdays HELP screen.
--ron

bpeltzer

Calculate Number of Days Between Dates Minus Weekends

Check the NETWORKDAYS function, part of the analysis toolpak.

"Melissa" wrote:

I am trying to calculate the number of days between two given dates minus the
weekends. Is there a formula that does this?

Melissa

Calculate Number of Days Between Dates Minus Weekends

That's it. Thanks Ron.

"Ron Rosenfeld" wrote:

On Mon, 6 Mar 2006 10:49:30 -0800, Melissa
wrote:

I am trying to calculate the number of days between two given dates minus the
weekends. Is there a formula that does this?

Look in HELP for NETWORKDAYS. You will need to have the Analysis ToolPak
installed. The directions to do that are with the Networkdays HELP screen.
--ron

All times are GMT +1. The time now is 12:06 AM.