WEEKDAY function problem

[Mikebra]

Hi all, Can anyone help with what is probablya simple problem but it's got me stuck.
When enter a date in cell A1 I want to return the day of the week as a number in A2. I am using the WEEKDAY function but it is reurning obscure dates rather than the day number

Thanks

Mike Bra

[Fotis1991]

=weekday(a1)

[wenqq3]

Some add on explanation :D
WEEKDAY( serial_number, [return_value] )
serial_number is a date expressed as a serial number or a date in quotation marks.
return_value is optional. It is the option used to display the result. It can be any of the following values:

Value Explanation
1 Returns a number from 1 (Sunday) to 7 (Saturday). This is the default if parameter is omitted.
2 Returns a number from 1 (Monday) to 7 (Sunday).
3 Returns a number from 0 (Monday) to 6 (Sunday).

[ragulduy]

That is what the weekday function does... can you give some examples of the obscure dates? How you are using the weekday function (the formula)? Or post an example workbook?

[codeslizer]

Are you trying to get the day of the week like Monday, Tuesday and so on..? If yes, below is the code, if just the day number - Fotis has already answered it.

Please Login or Register  to view this content.

[daddylonglegs]

When enter a date in cell A1 I want to return the day of the week as a number in A2. I am using the WEEKDAY function but it is reurning obscure dates rather than the day number

That's a simple formatting issue, Mike - A2 has a date format, change to general

[Mikebra]

Hi Guys, Thanks for all the replies, Problem sorted I couldn't see the wood for the trees.

Mike