By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
425,705 Members | 1,891 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 425,705 IT Pros & Developers. It's quick & easy.

Calculate end date

P: 28
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.

Jan 8 '09 #1
Share this Question
Share on Google+
2 Replies

Expert Mod 15k+
P: 31,411
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.
Jan 8 '09 #2

P: 28
Thank you for your help.
Jan 15 '09 #3

Post your reply

Sign in to post your reply or Sign up for a free account.