I have excel file with all the dates of a year seperated in columns like monday, tuesday, wednesday, thursday, friday, saturday and sunday as datatable. There are empty spaces in columns which represents holidays.
I want to fill in a dynamic value (date) like for example 01-01-2022 and then from that point in the column I want to copy every cell below it (as its +7 days) till 24 cells have past. If there is a blank space I want to skip that cell. So it doesn’t count as 1 in the 24 cells below.
Can someone help me with point me in a direction in how to do this. I can’t figure out how to extract a range within a datatable starting from a dynamic point.