Workday calculation - not working
No such function as WORKDAYS.....WORKDAY........yes........ but not what you
need here.
You want NETWORKDAYS function.
=NETWORKDAYS(A1,B1)
Gord Dibben MS Excel MVP
On Tue, 18 Jul 2006 12:23:01 -0700, LOK wrote:
Hi,
I'm trying to make a time and events schedule to track a project's progress.
basically in A1 will be the start date, B1 will be the end date, and I want
to know the number of workdays, not including weekends it will take to
complete this part of the project in C1. I've entered the =WORKDAYS(A1,B1)
formula and I keep getting either the #VALUE? or #NAME? response. I've added
the Analysis ToolPak ADD-IN so I don't understand why this isn't working -
HELP!
|