macro to copy out rows that have a start date, end date, and days of week into separate days

[richardsonyyc]

Hi Everyone,
New to this as a member but have referenced mrexcel.com for years. Great site and resource!

I'm trying to create a macro that will copy out rows of data based on a start date, end date, and days of week into individuals single dates. I've found ways to break out the date range but not with respect to the days of week within and am stuck. Here is a sample of what I want to convert. Any help is greatly appreciated.

FROM THIS
Flight	Start Date	End Date	Days of Week	Dept Station	Dept Time	Arvl Station	Arvl Time	Aircraft Type
999	22-Apr-19	29-Apr-19	1.3.5..	LAS	18:45	LAX	20:00	73H
999	1-May-19	6-May-19	1.34.6.	LAS	18:30	LAX	19:45	73W
TO THIS
Flight	Date	Weekday	Dept Station	Dept Time	Arvl Station	Arvl Time	Aircraft Type
999	22-Apr-19	1	LAS	18:45	LAX	20:00	73H
999	24-Apr-19	3	LAS	18:45	LAX	20:00	73H
999	26-Apr-19	5	LAS	18:45	LAX	20:00	73H
999	29-Apr-19	1	LAS	18:45	LAX	20:00	73H
999	1-May-19	3	LAS	18:30	LAX	19:45	73W
999	2-May-19	4	LAS	18:30	LAX	19:45	73W
999	4-May-19	6	LAS	18:30	LAX	19:45	73W
999	6-May-19	1	LAS	18:30	LAX	19:45	73W

<colgroup><col style="mso-width-source:userset;mso-width-alt:4461; width:92pt" span="9" width="122"> </colgroup><tbody>
</tbody>

 

[JLGWhiz]

In Excel and VBA, Weekday 1 is normally Sunday. Sow 2 thruough 6 would be Monday Through Friday. If you used the fuction =WEEKDAY(4/22/2019) it would return 2.