Excel Date

[strayerld]

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??

 

[Mike H]

Hi,

Is this what you mean

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

Mike

 

[JBeaucaire]

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

 

[AnotherNewGuy]

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

 

[David Biddulph]

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

 

[AnotherNewGuy]

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

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