Custom Formatting for Dates

N

nastech

Is there a manner of formatting to see date as Text?, if entered in same
cell. Think that is what I need. Using custom formatting: yymmdd and
making column narrow, so just see dd (with right justify).

Problem is that going from text to date format, just see ##
is there way to make yymmdd in custom to conform to text??? Thanks
 
N

nastech

Hi, thanks for that.. don't know that much, But can I enter something like
that in custom formatting for date? (trying for all in same column, already
have yymmdd in custom formatting) Thanks
 
R

Ralph Orth

I just noticed your other post, and changing the system date format in the
control panel will not affect the way Excel displays the date. I can't figure
out of you are working with a date or text from what you are writing, but I
think it is a date since it displays ## when you make the column narrow. In
your sheet, highlight the cells you want to display as just a day, then on
the menu bar on top, choose Format, then Cells, then Custom--in the Type box,
type dd. Then go and change your system clock back to what you would like it
to show in the lower RH corner.
 
N

nastech

thanks,, system clock? don't think mentioned that, not using clock anyways,
because takes up space for task buttons, incidently/ would ask MS to put at
left under start, where empty anyways.. since you're here: 2nd problem was:
xxxxx

Trying to make a custom format for date using yymmdd

Iam looking for a formula for conditional formatting, that will change color
if date is older than 1 business day: (exclude saturday/sunday, legal
holidays if possible)
format using is: yy-mm-dd (closest could get to: yymmdd)

Closest I have is:

=DATEDIF(TODAY(),$A2,"M")<6

if trying to get true for < 6months, WHAT NEED: (if just dd) don't know how
to modify it for if older than 1day. This is for Conditional Formatting.
Thanks


xxxxxxxxxx
 
B

Bob Phillips

Use a formula of

=workday(TODAY(),-1)<(TODAY()-1)

which requires the Analysis Toolpak being installed

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
Top