Forum Discussion
Solved
Excel spill formula days of the week to actual dates
Hi, hopefully someone can give me a little push in the right direction. I have a table regarding holiday hours with years and weeks on the rows and in the columns the different days of the weeks (se...
I think it might be more efficient to first prepare the data with power query and put the days on the rows.
That may be. I work in a Mac environment and don't have power query.
Can you share what the raw data is? In its raw form.
mathetes I gave it another try and came up with the attached. However I think it might be more efficient to first prepare the data with power query and put the days on the rows.
I think it might be more efficient to first prepare the data with power query and put the days on the rows.
That may be. I work in a Mac environment and don't have power query.
Can you share what the raw data is? In its raw form.