Good day, Gurus
I am working on the attached Workbook. This forum helped me with transferring data from one sheet to another but now I have created myself a new problem. My "Information" tab has 2 this 2 rows named: "Leave Start Date" and "Leave End Date." What I want to do is, if I enter a range of dates between the 2 rows, Excel will take all the working days between those dates (minus weekends) and list them one row after the other in my "Table" worksheet. I want to use the data available in the "Table" worksheet to create a dashboard later on. I have attached a sample Workbook for your reference.
Much thanks in advance.
Bookmarks