I am creating a timesheet. In this timesheet, I have a date field named "PPSD1". I have made a table for the days in this pay period. In this table, there are fields for the days of the week. I have inserted the below code, which takes the date I enter into "PPSD1" and calculates the day of the week, inserting it into a field named "Day1".
, "MM/DD/YYYY"), "EEEE")
What I need to do, is have it calculate the remaining days of the week automatically based on this first entry.
For example, if I enter 06/01/2010 into "PPSD1", then it returns "Tuesday" into "Day1". I need it to put "Wednesday" into "Day2"; "Thursday" into "Day3", etc.