Convert Date to Day of Week?

  cstirrat 11:15 11 May 10
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 10

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 10

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.

Nintendo Switch review: Hands-on with the intuitive modular console and its disappointing games…

1995-2015: How technology has changed the world in 20 years

Method Studios' title sequence for BBC series Taboo is truly unsettling

Best Pages for iOS tips | How to use Pages for iPad & iPhone: 6 simple tips to get more out of…