how to prevent date format change

Originally Posted by Marcol

Slightly different from martin

In F2 (helper column)

=TEXT(E3,"mmm")

Drag/Fill Down

Sort A:F (Two conditions)
By:= Helper Column > Ascending
Then by:= Date > Ascending

Then apply filter to Helper Column:= "Jan"

Hope this helps

Tip:=Posting a sample workbook, rather than some text in your post, is always an advantage.

I understand that you fill in F2 with =TEXT(E3,"mmm") then drag/fill down.

How do you do the following steps?
Sort A:F (Two conditions)
By:= Helper Column > Ascending
Then by:= Date > Ascending

Then apply filter to Helper Column:= "Jan"


In the F1 cell, I can select either Aug, Jan, Mar, how can I add more months?


How do you make the F1 cell with the drop down menu?


Thanks for your patience. I am a beginner, so some things that you mentioned I may not know what are the steps to do to achieve it.