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

Intel Coffee Lake release date and specifications

12 Amazing British Craft Beer Label Designs

watchOS 4 review

Les meilleurs navigateurs internet 2017