I have a format with effective date ranges to and from with days of the week. What would be the best way to get it into date specific format versus a range?
I'm adding and example of the Excel to this post. I would appreciate any advice or direction.
This is an example of my input:
Also, this is an example of the output I'm trying to get.
Thank you!
Solved! Go to Solution.
@Grisham312 what is the logic to calculate the desired output?
@Qiu A better approach.
@PhilipMannering
Your words mean a lot😂