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

N

nastech

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
 
R

Rick Rothstein \(MVP - VB\)

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
 
P

Pete_UK

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
 
O

OssieMac

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
 
N

nastech

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. -
 
Top