I have a database that lists events by date. I would like to add a field called Week Ending Date. I would like this date to be calculated from the date field to show the end date for the period. For example: the Date Field's for events are shown as 11/10, 11/12, 11/13. My week ending date every week is a Friday, in this case 11/16. I need a Week Ending Date field in the record to show 11/16, calculated automatically. How do I write the calcualtion given Friday as the week ending date every week for the Week Ending Date field. Thanks for your help.