I like to have a calendar date view of the five working days in Excel.
I manually built a first row with dates from 30th July 2018 to 3rd Aug 2018 (Mon to Fri, which are working days) and a second row with dates from 6th Aug 2018 to 10th Aug 2018.
I want to do the same using some inbuilt functions or through automation.
Unfortunately, I'm unable to add images as I am getting a warning saying I need 10 reputations to add an image. Therefore, I have tried to depict the same below as if it were in Excel:
A B C D E 1/10/18 2/10/18 3/10/18 4/10/18 5/10/18 8/10/18 9/10/18 10/10/18 11/10/18 12/10/18