Hi
I would be grateful if anyone can help me with the below.
So using the Holiday Start date as the first date until the holiday end date using 04/03/2023 and the holidays are then indicated using the multiple choice box example below
The MS form be filled like below as an example
Holiday Start = 20/02/2023
Holiday End = 04/03/2023
["1.Mon","1.Tue","1.Wed","1.Thu","1.Fri","1.Sat","2.Sun","2.Mon","2.Tue,"2.Wed","2.Thu","2.Fri"]
Using the above info I would like this convert into an HTML table on an email with dates to indicate it's a Holiday like the below.
Date Day Inicate Holiday
| 20/02/2023 | MON | H |
| 21/02/2023 | TUE | H |
| 22/02/2023 | WED | H |
| 23/02/2023 | THU | H |
| 24/02/2023 | FRI | H |
| 25/02/2023 | SAT | |
| 26/02/2023 | SUN | |
| 27/02/2023 | MON | H |
| 28/02/2023 | TUE | H |
| 01/03/2023 | WED | H |
| 02/03/2023 | THU | H |
| 03/04/2023 | FRI | H |
Kind regards
Carl
