I need help in Excel to figure out how to get the following date format:
Mon, 9-Jan-2013
If you already have a date (but the wrong format)
DDD, D-MMM-YYYY
If you want the current date in your desired format
=TEXT(NOW(),"DDD, D-MMM-YYYY")
This is how I would do it, using Today as the date in question.
=CONCATENATE(TEXT(TODAY(),"ddd"),", ",TEXT(TODAY(),"d-mmm-yyyy"))