Friday Factor...please help..!!

[MI man]

Hi guys..!!

I'm working on an MS Access Database where in I have to calculate the deadlines for tasks people input (in the form of data). But the problem is if it's a Friday, then the task should skip one day.

For instance: in general, a task would have its deadline as 1 day.
If the task is assigned on Monday, it must be finished by Tuesday.
But, if the task is assigned on Thursday, then it should skip Friday, and deadline must be returned as Saturday.

Any help..???

 

[gemma-the-husky]

in simple terms, one way is after you calculate the deadline just have

if weekday(deadline) = vbfriday then deadline = deadline +1

(ie add an extra day)

--------
dates only really get tricky when you have to check for public holidays!