How can i count the number of working days between 2 dates

[Galt]

Hi,

i would like to count the number of working days between 2 dates.
how can i do it?


Thanks!
Gal

[Maui_Jim]

Gal,

I typically use the NETWORKDAYS function, which is available through Excel?s Analysis Tool Package.

If your two dates are in cell A1 and B1, you might use this formula:
=NETWORKDAYS(A1,B1)-1
This displays the total number of Week Days between the dates.

If you wanted a more detailed result, you could use this formula:
=(NETWORKDAYS(A1,B1)-1-(MOD(B1,1)< MOD(A1,1)))&" days "&TEXT(B1-A1,"h"" hours ""m"" minutes""")
This displays the number of days, Hours & Minutes between the dates.

You will need to activate the Analysis ToolPak for this function:

How to install the Analysis ToolPak Add_In:
> Click the Tools dropdown menu
> Choose Add-ins... from the menu
> In the Add-ins dialog box, select the check box for Analysis ToolPak
> Click OK to close the Dialog box

Hope this helps,
Jim

[Galt]

HI,

Thanks for the reply,

sorry for missleading, but i was talking about MS Project.

altough, its always nice to learn something new


anyone have an idea? how do i count the number of working days between 2 dates, according to MS Project general calendar, so it will remove weekends and holidays?

Thanks

[Mal Farrelle]

Hi, I am away from MS Project right now so can't check the syntax . . . it is either DateDiff or DateDifference or ProjectDateDiff or ProjectDatedifference . . . search the helpfile.

Mal

[t shyamala]

hi, is there any way to count the number of resources(resource names column contains the names) used in a MS project 2010? whether any way to achieve through VBA macro?....consider the resource names as R1,R2 and so on...I need the count of R1, R2 respectively....Thanks in advance.....