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.

Surface Pro (2017) vs Surface Pro 4

20 groundbreaking 3D animation techniques

How to mine Bitcoin on Mac