I have two columns of Dates. I need a result of Date 2 minus Date 1. This is
pretty simple. this will tell me the number of days. But I need the result to
show me only Business days (i.e., Number of Days in result with no Weekends
--- Saturday and Sunday, excluded).

Please help.

Regards,
Sheikh Saadi

Take a look at =networkdays() in excel's help.

You will have to load the analysis toolpak if you haven't already--but excel's
help will describe how to do that.

(There's another function that you may want to look at, too: =workdays().)

Sheikh Saadi wrote:

I have two columns of Dates. I need a result of Date 2 minus Date 1. This is
pretty simple. this will tell me the number of days. But I need the result to
show me only Business days (i.e., Number of Days in result with no Weekends
--- Saturday and Sunday, excluded).

Please help.

Regards,
Sheikh Saadi

--

Dave Peterson

Hi Dave,

Thansk for your prompt response. But from the freaky data that I
currentlyhave, I just do not have any idea how many holidays would be there.
Can you please tell me about something automated.


Regards,
Sheikh Saadi


"Dave Peterson" wrote:

Take a look at =networkdays() in excel's help.

You will have to load the analysis toolpak if you haven't already--but excel's
help will describe how to do that.

(There's another function that you may want to look at, too: =workdays().)

Sheikh Saadi wrote:

I have two columns of Dates. I need a result of Date 2 minus Date 1. This is
pretty simple. this will tell me the number of days. But I need the result to
show me only Business days (i.e., Number of Days in result with no Weekends
--- Saturday and Sunday, excluded).

Please help.

Regards,
Sheikh Saadi

--

Dave Peterson

You can either ignore the holidays (don't include it in your formula) and you'll
be left with just the weekday difference.



Sheikh Saadi wrote:

Hi Dave,

Thansk for your prompt response. But from the freaky data that I
currentlyhave, I just do not have any idea how many holidays would be there.
Can you please tell me about something automated.

Regards,
Sheikh Saadi

"Dave Peterson" wrote:

Take a look at =networkdays() in excel's help.

You will have to load the analysis toolpak if you haven't already--but excel's
help will describe how to do that.

(There's another function that you may want to look at, too: =workdays().)

Sheikh Saadi wrote:

I have two columns of Dates. I need a result of Date 2 minus Date 1. This is
pretty simple. this will tell me the number of days. But I need the result to
show me only Business days (i.e., Number of Days in result with no Weekends
--- Saturday and Sunday, excluded).

Please help.

Regards,
Sheikh Saadi

--

Dave Peterson


--

Dave Peterson

thanks Sir,

My problem is solved with your great help. that seems to me a big one but
turns out the tiny one with your help. I owe you sor this. thaks again.

Best Regards,
--
Sheikh Saadi


"Dave Peterson" wrote:

You can either ignore the holidays (don't include it in your formula) and you'll
be left with just the weekday difference.



Sheikh Saadi wrote:

Hi Dave,

Thansk for your prompt response. But from the freaky data that I
currentlyhave, I just do not have any idea how many holidays would be there.
Can you please tell me about something automated.

Regards,
Sheikh Saadi

"Dave Peterson" wrote:

Take a look at =networkdays() in excel's help.

You will have to load the analysis toolpak if you haven't already--but excel's
help will describe how to do that.

(There's another function that you may want to look at, too: =workdays().)

Sheikh Saadi wrote:

I have two columns of Dates. I need a result of Date 2 minus Date 1. This is
pretty simple. this will tell me the number of days. But I need the result to
show me only Business days (i.e., Number of Days in result with no Weekends
--- Saturday and Sunday, excluded).

Please help.

Regards,
Sheikh Saadi

--

Dave Peterson


--

Dave Peterson

Glad you got it working.

Sheikh Saadi wrote:

thanks Sir,

My problem is solved with your great help. that seems to me a big one but
turns out the tiny one with your help. I owe you sor this. thaks again.

Best Regards,
--
Sheikh Saadi

"Dave Peterson" wrote:

You can either ignore the holidays (don't include it in your formula) and you'll
be left with just the weekday difference.



Sheikh Saadi wrote:

Hi Dave,

Thansk for your prompt response. But from the freaky data that I
currentlyhave, I just do not have any idea how many holidays would be there.
Can you please tell me about something automated.

Regards,
Sheikh Saadi

"Dave Peterson" wrote:

Take a look at =networkdays() in excel's help.

You will have to load the analysis toolpak if you haven't already--but excel's
help will describe how to do that.

(There's another function that you may want to look at, too: =workdays().)

Sheikh Saadi wrote:

I have two columns of Dates. I need a result of Date 2 minus Date 1. This is
pretty simple. this will tell me the number of days. But I need the result to
show me only Business days (i.e., Number of Days in result with no Weekends
--- Saturday and Sunday, excluded).

Please help.

Regards,
Sheikh Saadi

--

Dave Peterson


--

Dave Peterson


--

Dave Peterson