date calculation

[Redvibe]

Having trouble calculating a table of dates. I have two columns. One is to calculate 12 days from start date and the other 15 days. Catch is that the calculated dates must skip non-business days. Federal holidays are a given and then there are exception dates that I can make non-business days. Please help! I need this ASAP or I'll have to do it by hand. Thanks!

Date_List_2005.zip

[mr_vodka]

Take a look at this past thread. Also if you do a search for 'weekend' or 'holiday' I am sure there are past posts about it.

[Redvibe]

Thanks for the suggestion. That one seems to be a calculated field. Mine is set up as a script calculation. I actually started working on this a year ago. Someone set this up for me and it almost works but not quite. It doesn't always skip the non-business day. Sometimes it does though. If you run script number two and do find for 1/01/06..1/30/07, the first two rows are correct (it skips 1/2 and 1/16 as non-business days) but if you scroll down to 12/05/6 date it has a date of 12/26 in column one - that is marked as a non-business day.

[comment]

I think that if you want to calculate 12 work days from a date, you need to check each day and count it only if it's a work day - until your counter reaches 12.

[Redvibe]

isn't that what this is doing?

[Lee Smith]

There are a few different ways of looking at a work day calculation then merely subtracting one day from another.

You need to consider:

weekends

Holidays

number of days in the month.

Time Start, Day Start, Time End, and Day End.

Inclusive dates

There is a file in the Samples by BobWeaver, called Work days calc or something. You might want to take a look at it.

Lee