Archive of Mr Excel Message Board


Back to Dates in Excel archive index
Back to archive home

Convert date to day name?

Posted by Kevin Murphy on May 09, 2001 11:10 AM
I need to display a date format that looks like:
Wednesday, May 9.

Re: Convert date to day name?

Posted by GREGC on May 09, 2001 11:35 AM

=IF(WEEKDAY(I30)=1,"SUNDAY",IF(WEEKDAY(I30)=2,"MONDAY",IF(WEEKDAY(I30)=3,"TUESDAY",IF(WEEKDAY(I30)=4,"WEDNESDAY",IF(WEEKDAY(I30)=5,"THURSDAY",IF(WEEKDAY(I30)=6,"FRIDAY",IF(WEEKDAY(I30)=6,"SATURDAY",)))))))


Also

Posted by IML on May 09, 2001 11:43 AM

Assuming your date is A1, this should work as well"
=TEXT(A1,"dddd")&", "&TEXT(A1,"mmmm")&" "&TEXT(A1,"dd")

Good luck


Wanna use a custom format?

Posted by Mark W. on May 09, 2001 11:43 AM
If so, use: dddd, mmm d


Re: Also

Posted by IML on May 09, 2001 11:45 AM

One too many d's, try
=TEXT(A1,"dddd")&", "&TEXT(A1,"mmmm")&" "&TEXT(A1,"d")

to avoid it show the date as 09 instead of 9.

I think Mark's idea of a custom format will probably be best.



Do you want May or May?

Posted by IML on May 09, 2001 11:57 AM

Where by formula or format, if you want to show the full name of the month, use four m's. Three m's will get you Jan, Feb, Mar... whereas four will return January, Febuary etc...


I'm convinced he wants May : )

Posted by Mark W. on May 09, 2001 12:05 PM

This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.