View Full Version : How can i count the number of working days between 2 dates
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
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.....
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.