Deleting specific rows

%3CLINGO-SUB%20id%3D%22lingo-sub-2024944%22%20slang%3D%22en-US%22%3EDeleting%20specific%20rows%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2024944%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%20I%20created%20a%20column%20with%20dates%20from%20January%201st%20till%20years%20later.%20As%20I%20only%20want%20to%20see%20the%20Mondays%2C%20Wednesdays%20and%20Fridays%20is%20there%20any%20formula%20I%20could%20use%20to%20delete%20the%20other%20rows%3F%20Thanks%20for%20any%20answer!%20In%20the%20screenshot%20I%20manually%20deleted%20the%20rows.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2025016%22%20slang%3D%22en-US%22%3ERe%3A%20Deleting%20specific%20rows%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2025016%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F239055%22%20target%3D%22_blank%22%3E%40JOAK%20JOAK%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ELet's%20say%20your%20dates%20are%20in%20A2%20and%20down.%3C%2FP%3E%0A%3CP%3EIn%20another%20column%2C%20enter%20the%20following%20formula%20in%20row%202%3A%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3DWEEKDAY(A2)%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E(In%20Dutch%3A%20WEEKDAG)%3C%2FP%3E%0A%3CP%3EThen%20fill%20down.%3C%2FP%3E%0A%3CP%3ETurn%20on%20Filter.%3C%2FP%3E%0A%3CP%3EClick%20the%20dropdown%20arrow%20in%20the%20new%20column%2C%20and%20clear%20the%20check%20boxes%20for%202%2C%204%20and%206%2C%20then%20click%20OK.%3C%2FP%3E%0A%3CP%3EYou%20now%20see%20only%20the%20rows%20for%20Sunday%2C%20Tuesday%2C%20Thursday%20and%20Saturday.%3C%2FP%3E%0A%3CP%3EDelete%20all%20those%20rows%20in%20one%20go.%3C%2FP%3E%0A%3CP%3EFinally%2C%20remove%20the%20filter.%3C%2FP%3E%0A%3CP%3EOnly%20the%20rows%20for%20Monday%2C%20Wednesday%20and%20Friday%20remain.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

Hi, I created a column with dates from January 1st till years later. As I only want to see the Mondays, Wednesdays and Fridays is there any formula I could use to delete the other rows? Thanks for any answer! In the screenshot I manually deleted the rows.

1 Reply

@JOAK JOAK 

Let's say your dates are in A2 and down.

In another column, enter the following formula in row 2:

 

=WEEKDAY(A2)

 

(In Dutch: WEEKDAG)

Then fill down.

Turn on Filter.

Click the dropdown arrow in the new column, and clear the check boxes for 2, 4 and 6, then click OK.

You now see only the rows for Sunday, Tuesday, Thursday and Saturday.

Delete all those rows in one go.

Finally, remove the filter.

Only the rows for Monday, Wednesday and Friday remain.