As long as you don't need to worry about holidays, this should work:

Assume A1 contains the old weekday date. Then

=A1 - range - 2*INT(range/5)


In article ,
Casey wrote:

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.