Weekday in excel slicer, formatting issue

[Summerso1]

Hi All,

I have a slicer but its not holding the date formatting, I'm needing it to show the weekday, day,month, year which is dddd, dd,mm,yyyy. However the slicer puts the date back to dd,mm,yyyy and i really need the weekday in there. Any Ideas?

James

 

[billszysz]

Link to image with "how can do this"

https://drive.google.com/file/d/0B6UlMk8OzUrxeUtBenQ3dmw2Vnc/edit?usp=sharing

 

[Summerso1]

Thanks but this then orders by the week day so the dates are not in order

 

[billszysz]

Change formula
=TEXT(B3;"dd/mm/rrrr dddd")

oops...sorry
=TEXT(B3;"dd/mm/yyyy dddd")

 

[Summerso1]

yep this worked super star!!!

 

[billszysz]

But....this works only for a one month.
If you want correct sorting result for years and month, formula should be changed
=TEXT(B3;"yyyy/mm/dd dddd")