• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 256
  • Last Modified:

Syntax for Excel 2003 instead of 2007

I have this in a cell using Office 2007 but it doesn't work for users with 2003.  Can someone suggest a change so it will work with 2003?  (Holidays is a named range on the spreadsheet)

=WORKDAY(H4, -1, Holidays)

--Steve
0
SteveL13
Asked:
SteveL13
  • 2
1 Solution
 
zorvek (Kevin Jones)ConsultantCommented:
That function is in Excel 2003. It requires the Analysis ToolPak. To enable the Analysis ToolPak, choose the menu command Tools->Add-Ins, check on Analysis ToolPak, and click OK.

Kevin
0
 
zorvek (Kevin Jones)ConsultantCommented:
You will find here a formula that you can use instead of WORKDAY:

Title: Replacing the Analysis Toolpak Addin - Part 2
Link: http://www.dicks-blog.com/archives/2004/12/19/replacing-the-analysis-toolpak-addin-part-2/

Once you look at it though I think you will agree it is probably better to just add the Analysis Toolpak.

Kevin
0
 
barry houdiniCommented:
If you always want the previous workday then you can make that a bit simpler, i.e. using this formula

=H4-MIN(IF(WEEKDAY(H4-{1,2,3,4,5,6},2)<6,IF(COUNTIF(Holidays,H4-{1,2,3,4,5,6})=0,{1,2,3,4,5,6})))

That assumes that you never have more then 5 successive non-working days (either holidays or weekends)

regards, barry
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: Microsoft Office 2010

This course will introduce you to the interfaces and features of Microsoft Office 2010 Word, Excel, PowerPoint, Outlook, and Access. You will learn about the features that are shared between all products in the Office suite, as well as the new features that are product specific.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now