I'm new to Adobe and am having some issues making a "formula" to autofill dates in a table for a work time log. I'm not the best at explaining what I need, but below is a screenprint showing it. The Start Date is the only thing that is filled in by the teacher, while the following T-F;M-F Dates are autofilled as well as the Pay Period End Date. Total Hours Worked column is the total of the rows to the left of it, while the bottom Total Hours row is the total of the columns added down.
I'm having issues with these formulas - any help would be appreciated
Pretty hard to provide specific code without details like field names, formats, etc.
Do you also need a check so that the entered date is a Monday?
I've provided another screenshot below. The field names are "basic":
The first "bunch" of Monday-Friday would be in this format: Grading, Monday; Academic Support, Monday; etc.
The second "bunch" of Monday-Friday (lower half of table) would be in this format: Grading, Monday_2; Academic Support, Monday_2; etc.
The cell that is Total Hours Worked + Total Hours = Total Hours Worked, Total Hours
Also yes, the entered date "Pay Period Start Date" is a Monday with will match with "Monday" on the table.