CALCULATING WORKDAYS IN EXCEL

workdays · Mar 14, 2006

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?

Nick Hodge · Mar 15, 2006

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
[email protected]

workdays · Mar 15, 2006

You're a genius! I've read everything on calculating workdays online and no
one mentions that small detail. Bless you!!

workdays · Mar 15, 2006

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?

Nick Hodge · Mar 15, 2006

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
[email protected]