Sort End of Week

[SarikaB]

Hello Team,

I have created a End of week column in the CALENDAR table, however unable to sort it chronologically, How can I fix this?

Here is my end of week formula

cEOW = FORMAT([Date] + 4 - WEEKDAY([Date],2),"dd-mmm-yyyy")

Regards,

Sarika

[AlexisOlson · Accepted solution]

FORMAT returns a text value but you probably want a date. What if you remove the FORMAT wrapper and make sure it's a date type column and format the display via the column tools?