Date Related Query

[Arup Dutta Chowdhury]

Hi,
I have sample file in which date format is written as for example : 27/12/1988,14/9/1987. Now I want that if I filter the data it will show month wise becuase in the current data it is showing as year wise. How can I change it to month wise. Please help.

 

[Chihiro]

Add helper column with formula
=MONTH(B2)
and sort on that column.

 

[Khalid NGO]

Hi,

If you want to filter single month, Click on filter button > Date filters > All dates in the period > select appropriate month.

Else, use a helper column with:
=MONTH(B2)

Regards,

Edit: Chihiro was quick

 

[premjeetgupta]

Data Tab > Sort > Chose Custom List from (Order Drop Down) >Choose Month format > OK.