How to automatically delete rows in Excel based in day of week and date?

**pr0no** · 08-04-2012, 02:30 PM

Consider the following (partial) Excel worksheet:

Please Login or Register  to view this content.

In reality, there are over (the same) 500 dates for each of 100 companies (identified by id). I need to delete all rows which date falls on a saturday or sunday. In the example, March 12 and 13 (2011-03-12/13) and March 19 and 20 are Saturdays and Sundays. Second, I need to delete all rows with date 2011-07-04 (independence day; monday) and 2011-12-23 (friday before christmas).

Is this possible to do with either a formula or VBScript? I have never written a VBScript macro before (I have never had a use for it) so I would appreciate some help.

**MaczaQ** · 08-04-2012, 03:11 PM

i suggest to add 1 more column and write formula which will check if date in column B is Saturday or Sunday. Then use autofilter and then delete them. The sam way for Independence day and Friday before Christams (autofilter on column B)

You do not need any macro I think.