count workdays

[Ron Morris]

Hi,

Wanting to know if this is possible in either Excel or VBA.

I need to enter a start date in A1 - say 2/2/05
I need to enter an end date in A2 - say 2/7/05

In A3 I want to display the number of weekdays (or workdays). In this case, the number 3, based on the two dates provided.

Thank you,

Ron

 

[Tazguy37]

Can you use the NETWORKDAYS() funtion? You have to install the Analysis Toolpak for this, though.

(And wouldn't the correct answer be 4?)

 

[Aladin Akyurek]

Hi,

Wanting to know if this is possible in either Excel or VBA.

I need to enter a start date in A1 - say 2/2/05
I need to enter an end date in A2 - say 2/7/05

In A3 I want to display the number of weekdays (or workdays). In this case, the number 3, based on the two dates provided.

Thank you,

Ron

=NETWORKDAYS(A1,A2,Holidays)

where A1 <= A2 and Holidays (optional) refers to a range of holiday dates.

The function requires the Analysis Toolpak add-in.

 

[tactps]

You will need to install the analysis toolpak for this:

=NETWORKDAYS(A1,A2)

 

[GorD]

=NETWORKDAYS(A1,A2,Holidays)
which needs the analysis tool pack addin turned on

Also with your data that will give an answer of 4 Wed,Thur, Fri & Monday as it is inclusive if you need the answer to be 3 just add a minus 1

Hope that helps

 

[SydneyGeek]

Use the NETWORKDAYS function. For accuracy, create a separate table of holidays, and subtract any holidays from the total.

Denis

 

[tactps]

Guys - I think we have consensus on this issue (lol).

 

[Ron Morris]

Hey Taz,

Thanks alot, I didn't think it was going to be that easy!

Ron