Revised Date Question

S

Spectra

I'm sorry, I should have spelled my question out a little better. The
function added 3 days to the current date, but I need the 3 business days
added to the delivered date that equals the due date.

1. How do I add the three business days to the "delivered" date in your
function provided?

Monday delivered date = Thursday due date
Tuesday delivered date = Friday due date
Wednesday delivered date = Saturday due date, but switch to Monday due date
Thursday delivered date = Sunday due date, but switch to Tuesday due date
Friday delivered date = Monday due date, but switch to Wednesday due date

Also, does Access recognize the days of the week like this?
Sunday=1, Monday=2, Tuesday=3, Wednesday=4, Thursday=5, Friday=6, Saturday=7

One other question, if I wanted to insert specific holidays, how would I say
this?

Thank You So Much for Your Help!!!
 
Top