i'm currently working on a attendance solution for my work place. one of the criteria for this solution is to have a drop down calendar, which when the date is selected will auto populate the day names of the week as well as the dates for that week. the starting day, or day 1, is sunday. so, on any given day when a record is created/or selected, the day 1 field should always be sunday of that work week. the date field type is 'Date'.
what i currently have is below (with calculations):
and calculations are as follows:
the fields Day1Date (and so forth) has the calculation of Date - 1, Date - 2, etc., etc.
any help and assistance is greatly appreciated. thank you in advance.