Get day question

  • Thread starter Thread starter JG
  • Start date Start date
J

JG

My last question was answered fast and correct THANKS!

If I have a cell that has the date d/m/y how can I have the next cell auto
fill with the correct day?

|05-14-2004| Friday|

Thanks again Jeff
 
Jeff,

If your date is in cell A1, simply use the formula

=A1

and use the custom format

dddd

HTH,
Bernie
MS Excel MVP
 
If your date is in cell A1, simply use the formula
=A1

and use the custom format

dddd
Click to expand...

Or, if you need the day as text:
=CHOOSE(WEEKDAY(A1),"Sunday","Monday","Tuesday","Wednesday","Thursday","Frid
ay","Saturday")

Marcin
 
A more frugal way to get text would be to use

=TEXT(A1,"dddd")

--


For everyone's benefit keep the discussion in the newsgroup.

Regards,

Peo Sjoblom
 
If date is in A1, link B1 to A1 (type "=A1" into B1)

Choose Format then Cells. In list of categories, choose custom, the
in Type, put either "ddd" for three letter day code, or "dddd" for ful
day, e.g. "Thursday"
 
Thanks, this is just what I wanted !!!!!!!!!!!!


Peo Sjoblom said:
A more frugal way to get text would be to use

=TEXT(A1,"dddd")

--


For everyone's benefit keep the discussion in the newsgroup.

Regards,

Peo Sjoblom


=CHOOSE(WEEKDAY(A1),"Sunday","Monday","Tuesday","Wednesday","Thursday","Frid
Click to expand...
 
Back
Top