Hi everyone....
I need to find out how to add 10 working days onto a start date, i.e. if the start date is thursday I want to add the following 10 week days onto it and store it in another field, viz:
Startdate = Thursday 01/05/03 (ddmmyy format)
Enddate = 10 weekdays later ( Weds 14/05/03)
or
Startdate= Monday 05/05/03 (ddmmyy format)
Enddate= Friday 16/05/03 (ddmmyy format)
I need this to work out a target date 10 working days from a start date.
I need this for an urgent app, so I will offer many stars for your assistance.
I've looked at the FAQs and suggestions from similar questions (including one of mine), but they calculate the working days between two known dates which is not quite what I need.
Thanks in advance.
I need to find out how to add 10 working days onto a start date, i.e. if the start date is thursday I want to add the following 10 week days onto it and store it in another field, viz:
Startdate = Thursday 01/05/03 (ddmmyy format)
Enddate = 10 weekdays later ( Weds 14/05/03)
or
Startdate= Monday 05/05/03 (ddmmyy format)
Enddate= Friday 16/05/03 (ddmmyy format)
I need this to work out a target date 10 working days from a start date.
I need this for an urgent app, so I will offer many stars for your assistance.
I've looked at the FAQs and suggestions from similar questions (including one of mine), but they calculate the working days between two known dates which is not quite what I need.
Thanks in advance.