0

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

Mon, 9-Jan-2013

0

2 Answers 2

2

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
0

This is how I would do it, using Today as the date in question.

=CONCATENATE(TEXT(TODAY(),"ddd"),", ",TEXT(TODAY(),"d-mmm-yyyy"))

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .