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

 

[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.