Dates

I have a problem with the DateAdd function

lets say the project is going to end in 35 days

the project is working day is 6 days a week

the report need to give a date in 35 days from now

using 6 days of working days or 5 or 7 working days ?

well 7 days is easy but 5 or 6 or 4 or 3 i have problem with

It sounds like you are trying to add 35 work days to todays date. You can't use the DateAdd function alone. You will need custom code to determine the actual number of days to add. Does your non-work day change (ex. Sunday one week, Sat. the next)? Is it always 6 days or is it based on a special calendar using holidays?|||the work days can change and holiday will be nice to have but it's not require.
i have problem with the custom code to change the workdays around to find out when the project will finish|||How are you tracking how many work days there are in a particular week? Are you storing the information anywhere?|||the information is enter in the website.
I have a field in the column of the table
the project manger will enter how many days per week they will be working for the week
or rest of the project life. the days per week doesn't change too much
but it does happen.