View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
LOK LOK is offline
external usenet poster
 
Posts: 2
Default Workday calculation - not working

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!
--
thanks, L