Convert Date to Day of Week?

  cstirrat 11:15 11 May 2010
Locked

Anyone know how to convert a date format, e.g. 21/05/10 to 'Fri' please?
It would save me a lotta time n effort if I knew.
Thanks in advance.
C.

  Fruit Bat /\0/\ 11:20 11 May 2010

Use Excel

Try this

=CHOOSE(WEEKDAY(A1),"Sunday","Monday","Tuesday","Wednesday","Thursday","Friday","Saturday")


Day of the week calculater at bootom of page click here

  mgmcc 11:27 11 May 2010

Just enter the date and format the cell as "ddd" to display it as Mon, Tue, Wed etc, or "dddd" to display Monday, Tuesday, Wednesday etc.

This thread is now locked and can not be replied to.

Elsewhere on IDG sites

Xiaomi Mi Mix 2 review

See mcbess's iconic style animated for Mercedes-Benz

iPhone X news: Release date, price, new features & specs

Black Friday 2017 : date, sites participants & bonnes affaires