Day of the week return in B column based on date on A column

J

Julian

I'd like to have the days of the week (Monday, Tuesday etc) returned in
column B based on the date in column A. What would the formula would be.
Julian
 
R

Ron Rosenfeld

I'd like to have the days of the week (Monday, Tuesday etc) returned in
column B based on the date in column A. What would the formula would be.
Julian
Click to expand...

=text(a1,"dddd")

or merely

=A1 and custom format as "dddd"
 
Top