Count the Number of Workdays
"T. Valko" wrote:
Some clarification...
=SUM(INT((WEEKDAY(A1-{1,2,3,4},2)+B1-A1)/7))
{1,2,3,4} represents the weekday numbers that you want the count for.
Whe
1 = Monday
2 = Tuesday
3 = Wednesday
4 = Thursday
5 = Friday
6 = Saturday
7 = Sunday
--
Biff
Microsoft Excel MVP
"T. Valko" wrote in message
...
One way...
A1 = start date
B1 = end date
=SUM(INT((WEEKDAY(A1-{1,2,3,4},2)+B1-A1)/7))
--
Biff
Microsoft Excel MVP
"Rocetman" wrote in message
...
Trying to figure how I can take a start and end date and count the number
of
work days based on a Monday through Thursday work schedule. Does
NetWorkdays
function have a special operative that will enable me to perform the
above
condition.
.
This helps a great deal, but is there a way to exclude the major holidays such as Christmas, New Years, Labor Day, Thanksgiving, Memorial Day, and 4th of July. Even though this would be a simple task for one year by setting up a string in a seperate column, but I would need to count for several years since the job that I am on would last at least 10 years. Have any suggestions that Excel could automatically exclude the above holidays in "count the Number of workdays"?
|