Hi,
I have a single cell named range into which, goes an integer
representing a number of weekdays. This number is subtracted from a
column of dates (Data Validation prevents entry of a weekend date in
this column) to hopefully produce another weekday in another column.
Something like:
old weekday date - named range integer =new weekday date
I would like to avoid the Workday function simply because I share this
file with different people that are constantly changing and it is a
pain to attach instructions for installing the Analysis Tool Pak.
Anyone have a brilliant solution? Many thanks in advance.
--
Casey
------------------------------------------------------------------------
Casey's Profile:
http://www.excelforum.com/member.php...fo&userid=4545
View this thread:
http://www.excelforum.com/showthread...hreadid=397219