date format for D / DD to be (e.g.) m mo

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
Click to expand...

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

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

Rick
 
One or two d's (or D's) are used to represent numerical values as in
dates, eg d/mm/yyyy or dd/mm/yyyy.

Three d's in a format are taken to represent a three-letter day (Mon,
Tue, Wed etc), whereas four d's would represent the full day (Monday,
Tuesday, Wednesday etc).

There is no formatting trick that will give you M or Mo for Monday,
but you could use something like this:

=CHOOSE(WEEKDAY(A1),"Su","Mo","Tu","We","Th","Fr","Sa")

where there is a date in A1.

Hope this helps.

Pete
 
You can nest formulas to obtain various formats.

Examples:

=TEXT("10/9/2007","ddd") will return day of week as 3 character abbreviation.

=LEFT(TEXT("10/9/2007","ddd"),1) returns first character of day of week.

=LEFT(TEXT("10/9/2007","ddd"),2) returns first 2 characters of day of week.

=LOWER(LEFT(TEXT("10/9/07","ddd"),1)) returns first day of week in lower case.

Note that the dates in the above formulas can be a reference to a cell
containing a date.

=LOWER(LEFT(TEXT(A1,"ddd"),1)) where A1 contains a date.


Regards,

OssieMac
 
ahhh.. sorry answers would 99% time been what need because I'm just average
user, and I did not give enough info, this one thing been running into
often.

know all the rest, look good answers; but where I see DD or D might
already be covered by: dd or d for number day eg: 5 or 05 for 5th of
month, I think that if the D or DD are just redundant then could use as
suggested: (Custom Format) D = m for monday, or DD = mo

like may have said, have large need for this formatting as an automatic
Custom Format. - thanks much. -
 
Back
Top