PDA

View Full Version : MS Excel 'Day of the Week' formula



29-03-2002, 06:24 PM
Hi,
Does anyone know of an Excel formula for converting 'Dates' into the relevant 'Day of the Week'?

I have a spreadsheet with a lot of cells containing 'dates', eg 25/03/02. These dates are random and not sequential. I would like to know exactly what day of the week these cells relate to, by using a simple formula and not having to manually refer to a calender.

Thanks

Mike H
Taupo

29-03-2002, 06:35 PM
Type 'day of the week' into the excel help and it will give detailed instructions as to how to do this.

The way to do it is select the cells that need to be formatted. Clcik 'Format' then 'Cells' and select the correct format under the dates item or create your own.

JM

29-03-2002, 06:41 PM
Thanks very much

Mike H