Excel Date

S

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

AnotherNewGuy

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

AnotherNewGuy

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

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

date format 1
Preserving date format 1
date 2
Conditional formatting of date-cell - 2007 5
Excel 2003 keeps on changing the date that i entered. HELP PLEASE 1
Weird date format problem 2
Excel 2002: How to make the date format uniform ? 1
How to set the cell for date? 7

Top