Convert string to a table with dates

(1) Share

Report

Posted on by GeorgeRooney197

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

All responses (2)

Answers (0)

abm abm 32,464 Most Valuable Professional on at

Like (0)

Report

Re: Convert string to a table with dates

Hi @GeorgeRooney197

How you progressing this with one? If you need any further help please let me know.

Thanks
abm abm 32,464 Most Valuable Professional on at

Like (0)

Report

Re: Convert string to a table with dates

Hi @GeorgeRooney197

Please have a look at my video tutorial based on this and comment.

https://www.youtube.com/watch?v=Sjb7l10HHrE

Thanks