Generate date values for day columns

daraghwalker

I have the following dataset as a result of my workflow:

I would like to assign a date value (DD-MM-YYYY) to the columns Mon-Fri. The only indicator I have is the Week Ending value. How would I go about getting the date value for each day in my results?

I would like for the date to be displayed in a row above my first ID, so that the date will appear above my total hours, but under the day column names.

Thanks for the help!

Aaron_Harter

Hi @daraghwalker, 

Check out the attached solution to map the date values into your data table:

 

2020-04-23 3.yxmd