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

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.

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


--
Casey


------------------------------------------------------------------------
Casey's Profile: http://www.excelforum.com/member.php...fo&userid=4545
View this thread: http://www.excelforum.com/showthread...hreadid=397219