Adding business days to a date

[Keith R]

I have a spreadsheet with several thousand start dates; in another column I
have the number of business days to completion. I need to translate the
combination of the two into a "real" calendar end date.

I think that I can do something like
= startdate + (trunc(busdays/5))*7 + mod(busdays,5)

but that still leaves me with the potential for the mod to leave me in a
weekend (ends on a Friday, plus one puts me to Sat instead of Monday).

Are there any built-in functions related to business days that might make
this simpler? Also, if there are a few key dates that I want to add to my
list of non-business days (such as holidays, snow days, etc.) what is the
best way to do that as well?

Thanks!!
Keith

 

[JE McGimpsey]

Take a look at WORKDAY() in XL Help.

 

[Peo Sjoblom]

If you have the ATP add-in (comes with Excel) installed you can use


=WORKDAY(Start_date,25,Holidays)

So if you have a startdate in A1, a list of public holidays in H1:H11 and
you want the date when you add 25 business days you would use

=WORKDAY(A1,25,H1:H11)

it's cousin is NETWORKDAYS which will count business days between start and
end date

they are both in the help section in Excel