Excel Date
 

Realize date stored in cell not as mm/dd/yy format, but how can i get any of
the three from the date Ie; concatenate month(name or number) to a phrase??
--
LDStrayer

Excel Date
 

Hi,

Is this what you mean

=TEXT(MONTH(A1),"MMMM")

Mike

" wrote:

Realize date stored in cell not as mm/dd/yy format, but how can i get any of
the three from the date Ie; concatenate month(name or number) to a phrase??
--
LDStrayer

Excel Date
 

=year(a1)
=month(a1)
=day(a1)

You can wrap that into a TEXT formula and format the result, too.

=TEXT(DAY(A1),"DDDD") results in "Sunday"


--
JBeaucaire
------------------------------------------------------------------------
JBeaucaire's Profile: http://www.thecodecage.com/forumz/member.php?userid=73
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=46960

Excel Date
 

You'd need to use Weekday() instead of Day() as in =TEXT(WEEKDAY(A1),"DDDD")


=TEXT(DAY(A1),"DDDD") results in "Sunday"


--
JBeaucaire
------------------------------------------------------------------------
JBeaucaire's Profile: http://www.thecodecage.com/forumz/member.php?userid=73
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=46960

Excel Date
 

Why not just =TEXT(A1,"DDDD") instead of =TEXT(WEEKDAY(A1),"DDDD") ?
--
David Biddulph

"AnotherNewGuy" wrote in message
...
You'd need to use Weekday() instead of Day() as in
=TEXT(WEEKDAY(A1),"DDDD")


=TEXT(DAY(A1),"DDDD") results in "Sunday"
--
JBeaucaire

Excel Date
 

'cause it didn't occur to me? ;o)

I was just pointing out that the DAY() function won't give the desired
results.

"David Biddulph" wrote:

Why not just =TEXT(A1,"DDDD") instead of =TEXT(WEEKDAY(A1),"DDDD") ?
--
David Biddulph

"AnotherNewGuy" wrote in message
...
You'd need to use Weekday() instead of Day() as in
=TEXT(WEEKDAY(A1),"DDDD")


=TEXT(DAY(A1),"DDDD") results in "Sunday"
--
JBeaucaire