MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Incredibly annoying prob ->date conversion


Posted by John Smith on January 02, 2002 8:53 AM

This is really baffling me, its so simple yet I just cant do it.
I enter a set of dates in a field, i.e 22/10/01. What I need is a set of formula to convert that into a day number, and then, using a day sheet I have created (see screenshot), convert it into a day name. Thankyou very much in advance.


Posted by Jacob on January 02, 2002 10:34 AM

You might be making this harder than it is. Format the date as "DDDD" and it will display only the day name. If you need the day number i.e. 1-7 you can then get it from the displayed day.

Jacob