Hello All,
I am attaching a file herewith with problem I am facing.
In Cell C6 I have the Date Range for the Calendar Week 33 which I have done with the Text Function and concatenating the two cells B8 and B9.
My objective is to have the date in the format shown in Cell F6. When I will drag it across it should show the output as shown in Cell G6.
It should omit the weekends viz Sat and Sun.
The result when I dragged it from C6 to D6 is wrong.
Required output is shown in Cells F6 and G6
Any help would be greatly appreciated.
Bookmarks