Sunday, August 16, 2009

Count workdays by excluding Sundays from a date interval

In Excel 2007 you can calculate the workdays between start date and end date by using NETWORKDAY function. It even lets you point to a holiday array of your choice to exclude holidays.

If you need to exclude Sundays only because Saturday is a working day, you can achive this in several ways.

Here is a simple way to do so (as Miki Avidan suggested) :
* The dates shown here are in European DD/MM/YYYY format which doesn't affect the solution.

Start: B10
End: C10

=SUMPRODUCT(N(WEEKDAY(ROW(INDIRECT(B10&":"&C10)))<>1))

<>1 represent the exclusion of Sundays in the SumProduct function.

Click the image to enlage

No comments:

Post a Comment

Enter your comment here