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

[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

 

[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

 

[Max]

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

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

---

 

[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

 

[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

thanks for that will give it a go.
thanks all larry

 

[larry]

thanks for that will give it a go.
thanks all larry

that worked thanks all much appriciaded

 

[Mike Rogers]

Rick

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

Mike Rogers

 

[Ron Rosenfeld]

Rick

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

Mike Rogers

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

 

[Ron Rosenfeld]

Rick

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

Mike Rogers

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

 

[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

 

[larry]

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