Subtract number of Working Days

  • Thread starter Thread starter Casey
  • Start date Start date
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
 
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)
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Subtracting Dates with Empty Cells 3
Re: How can I count the number of SATURDAYS in a month? 0
number or working days 6
aging calendar days 2
Help with week day count with range 6
Counting depending on another column 4
Formula to get number of days excluding Fridays in a given period 17
Counting Days of Week in Date Ranges 1

Back
Top