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"
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Dealing with the error: unable to filter on excel hc home school 0
concatenate entries from a column into a cell by logical AND withanother column 2
Need some PWA help 0
Help to Highlight Excel Row based on Weekly Date Range 2
Date diffrence in days, weeks and months. 1
Setting column width in a table with a macro is not working 0
Automation of scanned file storage based on content 0
week numbers 7

Top