Calculate end date

[shimul]

Hi All,

If I set up a form with start date (choose from calendar) and end date. Each week Start date (Monday ) and want to automatically calculate end date (sunday each week) . how can I calculate an end date field and place it in the form,

It really giving me hard time, can someone help please?

As example start date : 2008/12/08, end date : 2008/12/14

Thank you.

Shimul

[NeoPa]

Have you considered using the Weekday() function. That should give you what you need to determine the last day of the week. You can even decide which day the week is considered to have started on if you want.

[shimul]

Thank you for your help.