Day formatting

[Rob]

I need to be able to input a date say 11/05/1995 and find
out which day of the week it was. Can anyone help please.
I can be emailed on (e-mail address removed)

 

[JE McGimpsey]

One way:


A1: 11/05/1995
B1: =A1

Format B1 with

Format/Cells/Number/Custom dddd

to display Sunday

alternatively, use a worksheet function:

B1: =TEXT(A1, "dddd")

 

[Frank Kabel]

Hi
several ways:
1. To return a weekday number use: =WEEKDAY(A1)
2. To get the name of the day you can either:
- Format the cell with the custom format "DDDD"
- use the formula: =TEXT(A1,"DDDD")

for more about dates and times have a look at
http://www.cpearson.com/excel/datetime.htm