Creating Custom Weekdays Order

[madhuchelliah]

Hello Folks, I am preparing a daily, weekly and monthly report. For weekly report I need a weekdays order from Thursday to Wednesday. When I pull data for this week in the filter it should filter from Thursday to Wednesday. Please suggest an idea whether in vba or formula. Thank you.

 

[RileyC]

Can you use tables in excel? You can filter in a table with a string comparison whether it's a Thursday, Friday, Saturday, Sunday, Monday, Tuesday, or Wednesday with relative ease. If worse comes to worse you can program in VBA for automation but in my opinion it would most likely be easier (and take around 10 seconds) with an excel table filter.