Hi
I am looking to copy/repeat data in a row, based on the dates in the columns. The week starts on Monday and ends on Sunday.
Is this possible please?
Thanks for any help
I am looking to copy/repeat data in a row, based on the dates in the columns. The week starts on Monday and ends on Sunday.
Is this possible please?
| Demo.xlsx | |||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| A | B | C | D | E | F | G | H | I | J | K | |||
| 1 | Absence Category | Absence Start Date | Absence End Date | Monday Date | Total Duration (Days) | Total Absence Duration (Hours) | Total Absence Duration (Days) | FTE | WTE | Hours | First Day Absent | ||
| 2 | Annual Leave | 06/05/2024 00:00 | 02/06/2024 00:00 | 06/05/2024 | 28 | 150.00 | 28 | 1.00 | 37.50 | 7.50 | Mon | ||
| 3 | Annual Leave | 15/04/2024 00:00 | 12/05/2024 00:00 | 15/04/2024 | 28 | 120.00 | 28 | 0.80 | 37.50 | 7.50 | Mon | ||
| 4 | Annual Leave | 01/02/2024 00:00 | 28/02/2024 00:00 | 29/01/2024 | 28 | 92.00 | 28 | 0.61 | 37.50 | 7.50 | Thu | ||
| 5 | Sickness | 25/12/2023 00:00 | 21/01/2024 00:00 | 25/12/2023 | 28 | 9.20 | 28 | 0.80 | 23.00 | 4.60 | Mon | ||
| 6 | Sickness | 15/07/2024 00:00 | 11/08/2024 00:00 | 15/07/2024 | 28 | 9.20 | 28 | 1.00 | 23.00 | 4.60 | Mon | ||
| 7 | Sickness | 15/07/2024 00:00 | 11/08/2024 00:00 | 15/07/2024 | 28 | 9.20 | 28 | 1.00 | 23.00 | 4.60 | Mon | ||
| 8 | Annual Leave | 22/07/2024 00:00 | 18/08/2024 00:00 | 22/07/2024 | 28 | 150.00 | 28 | 1.00 | 34.50 | 6.90 | Mon | ||
Sheet1 | |||||||||||||
Thanks for any help
