View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Rick Rothstein \(MVP - VB\) Rick Rothstein \(MVP - VB\) is offline
external usenet poster
 
Posts: 2,202
Default date format for D / DD to be (e.g.) m mo

don't know if need to make as suggestion or question, but with trying to
make
things fit in narrow columns / have less items to read for the same
info...

would think that MS could have made option available for day of week to
show
for 1 or 2 places, and maybe to be discerned between caps / lower case..

D for m (form monday)
DD for mo

is this available in some other form??? thanks


First Letter: =LEFT(TEXT(<<YourDate,"ddd"),1)

First Two Letters: =LEFT(TEXT(<<YourDate,"ddd"),2)

Rick