DISPLAYING WEEK DAY FROM DATE

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I know there is a simple formula for returning the actual week day name from a date, but I've forgotten the formula. I have a column of dates in column A and in column B I want to display the Day of the Week

Can someone please help ... I'm right in the middle of a project & am stuck. Thanks!
 
two ways

in cell be enter formula =a1 and change b1 formating to dddd

or


in b1 enter =text(a1,"dddd")
 
If you want the day name, use

=TEXT(A1,"dddd")

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

MARK said:
I know there is a simple formula for returning the actual week day name
Click to expand...
from a date, but I've forgotten the formula. I have a column of dates in
column A and in column B I want to display the Day of the Week.
Can someone please help ... I'm right in the middle of a project & am
Click to expand...
stuck. Thanks!
 
Hi Frank and Mark!

There's a happy accident here that applies to WEEKDAY second argument
1 using 1900 Date System

=WEEKDAY(A1)
Returns the day number where Sunday = 1, Monday = 2

This can be useful if we want to refer to the day number in a formula
(e.g. calculating weekend overtime rates). But we can format the
return dddd and it will return the day of the week in text.

Happy accident? Date serial number 1 represents 1-Jan-1900 and that
was actually a Monday. Excel, copying Lotus 1-2-3 copying.... has it
as a Sunday. The error corrects itself after Feb-28-1900 because Excel
has this as a Leap year when it wasn't. One danger here is changing to
the 1904 Date System where this formula would still return 4 but
formatting dddd would show one day earlier.



--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
I came across something similar recently and had to change
the actual settings on my computer (regarding how a date
was shown) rather than through Excel. Not sure if this
will help but might be worth a try...
 
Hi Norman
good point (I somehow remembered there was something with the first
leap year)
Though to be honest I probably misunderstood the OP in the start. T
thought he wanted a day NUMBER. After reading your reply he probably
wants the day NAME :-)
 
Hi Frank!

It depends what he wants to do with it. Normally the format of the
date ddd or dddd is OK for presentation purposes but having the
underlying day number can also be needed and that would make a
formatted WEEKDAY(A1) the better solution.

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
Back
Top