CALCULATING WORKDAYS IN EXCEL

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am using Excel from Microsoft Office 2000. I would like to add a certain
number of work dates to specific dates and have the spread sheet tell me what
the future date is. Microsoft Office gave me the formula =WORKDAY(A2,A3).
The begin date is in A2, the number of workdays to add is in A3, and the
formula is in A4. The result in A4 is #NAME?. Can anyone help?
 
The WORKDAY function in Excel is part of the analysis Toolpak add-in. Go to
Tools>Addins... and check analysis toolpak (Not the VBA one) and it should
then work

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
(e-mail address removed)
 
You're a genius! I've read everything on calculating workdays online and no
one mentions that small detail. Bless you!!
 
One more question on this. Is it possible to get the fictitious dates to
disappear...for example, if I have a blank begin date...a date in the
calculation cell appears based on the way Excel handles dates (i.e. 1900).
Is there a way for those dates not to show when the worksheet is blank and
waiting for entry by the user?
 
If I understand you need to wrap it all in an IF statement like so

=IF(A2="","",WORKDAY(A2,A3))

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
(e-mail address removed)
 
Back
Top