Hi again
I would require a formula to count the amount of workdays between cell a1 and cell a2.
Assume formula is in celll a3 and both a1 and a2 are date formated.
Hi again
I would require a formula to count the amount of workdays between cell a1 and cell a2.
Assume formula is in celll a3 and both a1 and a2 are date formated.
Last edited by vasto; 09-04-2009 at 11:08 AM.
here you go:
=NETWORKDAYS(A1,A2)
Mr MaGoo
Magoo.Inc MMVII
If i've helped please add to my Rep by Clicking on the Blue Scales in the top right hand corner of the post
Be sure to take a look at the Excel Help on this function.
If there are holidays that fall between your start date and end date then you may want to exclude these from the result, which will require a list of dates to exclude.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks