SteveL13
asked on
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
=WORKDAY(H4, -1, Holidays)
--Steve
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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(CO UNTIF(Holi days,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
=H4-MIN(IF(WEEKDAY(H4-{1,2
That assumes that you never have more then 5 successive non-working days (either holidays or weekends)
regards, barry
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