Day of Week

[Todd K]

Is there a function that would tell me what day of the week a date falls on?
For example, column A contains a date and column B would contain the formula
displaying the day of the week?

Thanks!
Todd K

 

[Todd K]

Nevermind.

I figured it out. I just used the WEEKDAY function.

Todd K

 

[Kevin M]

Todd,

In the cell you wish to display the day simply make it
equal to the date cell and then format the cell as Custom
and enter dddd in the custom selection.
A b
11/14/2003 =a1
B1 will now display 'Friday'
HTH
Kevin M

 

[Paul]

You don't need a function. Format the cell with the date in it as dddd.

 

[Kevin M]

Todd, WEEKDAY simply returns a number from 1 to 7, please
have a look at my other post regarding the issue.
HTH
Kevin M