Subtract number of Working Days

C

Casey

Hi,
I have a single cell named range into which, goes an intege
representing a number of weekdays. This number is subtracted from
column of dates (Data Validation prevents entry of a weekend date i
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 thi
file with different people that are constantly changing and it is
pain to attach instructions for installing the Analysis Tool Pak.

Anyone have a brilliant solution? Many thanks in advance
 
J

JE McGimpsey

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)
 
C

Casey

JE,
Brilliant! I will have to study how this works to understand it, bu
work it does.
I have worksheets that only I use that are set up with holiday lis
and use the Workday function, but this one is used by everybody. Man
thanks for the help
 
Top