Excel VBA code to return weekday name from a date then autofilters for userdefined weekday

I spent last night looking for an answer to my question but i didn't find anything specific to my ask.

I have a huge sheet that contains lots of data. In Column A, I have the Date and time. I would like to have a VBA code that does few actions.

1) Insert a column B next to column A that gives the weekday name. For example if the date in column A is January 10, 2016 8:30 then column B will have "Sunday"

2) Then the VBA code to filter this sheet based on Column B. For instance given a user input of a particular day (example Friday), the autofilter will filter for 4 days ahead ( Friday, Saturday, Sunday, Monday ).

3) The result of the autofilter then is copied to new blank sheet.

4) In the new sheet I want the vba to delete any row data for the same user defined day ( example Friday ) that has time of less than user defined time (example 8:00 am) in Column A. Finally shifting cells up to remove any blank rows.

Hope I am not overwhelming you with this problem, but I hope I get feedback from one of the brilliant minds in here

please send an excel file with dummy data and the exepected results

here is the sample