View Single Post
  #1   Report Post  
Casey
 
Posts: n/a
Default Subtract number of Working Days


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