PDA

View Full Version : How can i count the number of working days between 2 dates



Galt
09-07-2008, 05:42 AM
Hi,

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


Thanks!
Gal

Maui_Jim
09-08-2008, 08:51 PM
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
09-08-2008, 10:39 PM
HI,

Thanks for the reply,

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

altough, its always nice to learn something new :hi:


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
03-30-2009, 12:07 PM
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
07-10-2013, 11:21 PM
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.....