How to get a custom date format in Excel

I need help in Excel to figure out how to get the following date format:

Mon, 9-Jan-2013

Answer

If you already have a date (but the wrong format)

• format → cells → user defined: DDD, D-MMM-YYYY

If you want the current date in your desired format

• enter this formula: =TEXT(NOW(),"DDD, D-MMM-YYYY")


• you can replace NOW() with cell references like [A1] if this cell already have a valid date