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

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


"larry" wrote in message
...
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" wrote:
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
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

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!
================================================== ===

"larry" wrote in message
...
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 wrote:
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 wrote:
larry wrote:
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
that worked thanks all much appriciaded

Rick

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

Mike Rogers

"Rick Rothstein (MVP - VB)" wrote:

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


"larry" wrote in message
...
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

On Sat, 29 Dec 2007 18:07:00 -0800, Mike Rogers <Mike060349@NoxSpamxAOLDOTcom
wrote:

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

On Sat, 29 Dec 2007 18:07:00 -0800, Mike Rogers <Mike060349@NoxSpamxAOLDOTcom
wrote:

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

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

"Ron Rosenfeld" wrote:

On Sat, 29 Dec 2007 18:07:00 -0800, Mike Rogers <Mike060349@NoxSpamxAOLDOTcom
wrote:

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

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





Mike Rogers wrote:
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

"Ron Rosenfeld" wrote:

On Sat, 29 Dec 2007 18:07:00 -0800, Mike Rogers <Mike060349@NoxSpamxAOLDOTcom
wrote:

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