I want to calculate the number of days between 2 dates but want to exclude dates which fall on Saturdays or Sunday in any calendar year. Does anyone know a formula to do this.
I want to calculate the number of days between 2 dates but want to exclude dates which fall on Saturdays or Sunday in any calendar year. Does anyone know a formula to do this.
Hi
In excel every day is represented by a number 1-7
Snip from VBA help:
-----------------------------------------------
Argument Values
The firstdayofweek argument has the following values:
Constant Value Description
vbUseSystem 0 Use NLS API setting.
vbSunday 1 Sunday (default)
vbMonday 2 Monday
vbTuesday 3 Tuesday
vbWednesday 4 Wednesday
vbThursday 5 Thursday
vbFriday 6 Friday
vbSaturday 7 Saturday
-------------------------------------------------
look at this howto: http://www.cpearson.com/excel/distribdates.htm
You need to make sure you have the Analysis toolpack installed.
Tools>addins make sure Analysis Toolpack is ticked (if not tick it now, you may need your installation disk)
Then you can use the following formula:
=Networkdays(Startdate,Enddate,Holidays)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks