Day of Week

  • Thread starter Thread starter Todd K
  • Start date Start date
T

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,

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
 
Todd, WEEKDAY simply returns a number from 1 to 7, please
have a look at my other post regarding the issue.
HTH
Kevin M
 
Back
Top