How can I put in Date & have the Day come up

L

larry

What i am trying to do is put in date ie:- 30/12/07 and have sunday.
=a1(date)b2(day)
Thanks for any larry
 
R

Rick Rothstein \(MVP - VB\)

Assuming your date is in A1...

=TEXT(A1,"dddd")

That spells out the day's name in full... if you ever need the abbreviated
day's name, use only 3 d's instead of 4.

Rick
 
M

Max

larry said:
What i am trying to do is put in date ie:- 30/12/07 and have sunday.
.. =a1(date), b1(day)
Click to expand...

Presuming A1 down contains real** dates,
then in B1, copied down:
=TEXT(A1,"dddd")
will return the required day.

**Think your posted example: 30/12/07 is not a real date
To convert an entire col of dates to real dates at one go,
select the col, click Data > Text to Columns, click Next > Next
In step 3, check "Date", select: DMY from droplist, click Finish
 
R

RagDyeR

If A1 contains a "legal" XL date, in B1 enter
=A1
And custom format B1 to
ddd
OR
dddd
--

HTH,

RD
=====================================================
Please keep all correspondence within the Group, so all may benefit!
=====================================================

What i am trying to do is put in date ie:- 30/12/07 and have sunday.
=a1(date)b2(day)
Thanks for any larry
 
L

larry

larry said:
What i am trying to do is put in date ie:- 30/12/07 and have sunday.
=a1(date)b2(day)
Thanks for any larry
Click to expand...
thanks for that will give it a go.
thanks all larry
 
M

Mike Rogers

Rick

Is there a significant difference between your response and that of RagdyeR?

Mike Rogers
 
R

Ron Rosenfeld

Rick

Is there a significant difference between your response and that of RagdyeR?

Mike Rogers
Click to expand...

Mike,

Rick's response results in the TEXT of the date being returned.

Ragdyer's response leaves the date unchanged (it will still be a number) but
merely changes the formatting.

Ragdyer's method results in a value you can use in date calculations.
Rick's method results in a text string you can use in text manipulations.
--ron
 
R

Ron Rosenfeld

Rick

Is there a significant difference between your response and that of RagdyeR?

Mike Rogers
Click to expand...

Mike,

Rick's response results in a TEXT string. The result can be used by formulas
that manipulate text. It will ordinarily be left-justified.

Ragdyer's response results in a DATE value being in the cell. The result can
be used by date formulas (the value will be the same date as the original). It
will ordinarily be right-justified.
--ron
 
M

Mike Rogers

Ron

Thanks for the education. Just like anything else when you know what to
use, and when, it can make all the difference in the world.

Mike Rogers
 
L

larry

the one that rick gave me was the one i whanted.
thanks for the help have a good new year.every one
 
Top