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