Hey guys, So i'm trying to make a table where the headers are based on the dates from another tables headers. for example, if table1 headers are 8/14 8/15, 8/17,
i want the header in table 2 to say "week of 8/14
i have a pseudo code in mind, but not sure how to implement it
find previous monday from current cell
next cell
if previous monday is same as last cell's previous monday, move on next cell
else copy monday into header of table 2, etc.
i want the header in table 2 to say "week of 8/14
i have a pseudo code in mind, but not sure how to implement it
find previous monday from current cell
next cell
if previous monday is same as last cell's previous monday, move on next cell
else copy monday into header of table 2, etc.