Hi all,
I have an excel file, which shows a date when a task has been started on and the date the was task completed.
Is there a code that i can use which will work out how many days it took to complete the task.
For example
If cell A1 states 20/10/2009 and cell B2 states 26/10/2009
I need to find out how many days it took to complete this task knowing that the weekend falls during this period i need to know how many working days it took..
My works opening days are Monday to Friday.
use the newtworkdays function ensuring that your cells are formatted dd/mm/yyyy
=networkdays(A1,A2) should return 5
open fx (functions wizard to left of formula bar) select All and networkdays.... if you can't see this function go to tools-addins-select the analysis tool pack and download- you will now see the function
you may need to minus 1 as below if you want to count non inclusive days
=(NETWORKDAYS(B3,B5))-1
Last edited by somesoldiers; 10-21-2009 at 10:49 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks