MrExcel Publishing
Your One Stop for Excel Tips & Solutions

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.


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",)))))))

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

Also

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

Good luck

Posted by Mark W. on May 09, 2001 11:43 AM

Wanna use a custom format?

If so, use: dddd, mmm d

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

Re: Also

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.


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

Do you want May or May?

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

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

I'm convinced he wants May : )