=NETWORKDAYS( Startdate, Enddate, holidays)

I believe that depending on the version number of excel - you may need the
analysis toolpack installed

edvwvw

heater wrote:
I want to know how many workdays have pasted. In cell E6 is the first
workday and E7 is the ending Workday. What is the formula to know how many
Workdays have pasted?

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200905/1