Working Days function copied down column

M

Mally

Hi

What i'm wanting to do is add a certain number of working days excluding
holidays to a date. I've seen the formula below which works OK.

=start_date+IF(days=0,0,SIGN(days)*SMALL(IF((WEEKDAY(start_date+SIGN(days)*(ROW(INDIRECT("1:"&ABS(days)*10))),2)<6)*ISNA(MATCH(start_date+SIGN(days)*(ROW(INDIRECT("1:"&ABS(days)*10))),holidays,0)),ROW(INDIRECT("1:"&ABS(days)*10))),ABS(days)))

This only allows you to have one date as the start date. What i need is the
cells in column A will have different dates in and the cells in column B will
have the formula in. I need a formula that can be copied down column B that
will pick up the different dates in column A.

I can't use the analysis toolpack addin.

Thanks in advance for any help.
 
T

T. Valko

If I understand what you want just replace each call to start_date with the
cell reference. For example, A1. Then, as you copy down the cell ref will
increment accordingly.
 

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

number of months and days between two dates without approximation 3
Check dates against a date range. 0
Date + X days excluding holidays 1
Index and Match 5
IF statement in Array Formula's 6
Counting number of days excluding certain values 3
Need Help with a VBA subroutine 0
Diff in business days 2

Top