Thread: date formula required

Hi,

Can someone please help me with a formula I'm trying to work out.

It's to determine a job due date depending on when it is booked and paid and stock received.

It's a part of a table.

So one column is booked and the one next to it is paid and then stock and then the following one is due. If it is booked and paid by Thursday and stock by Friday, the job will be due 3 Sunday's away.

Any time after these days but before the following Thursday/Friday will mean due date will be following Sunday.

I hope that makes sense??

Can anyone help?

Thanks,

Matt