Custom Formatting for Dates

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

Guest

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Date Format Problems?? 5
DATE question 5
Date Formats 1
Remove date format? 3
Date Format problem 2
Formatting Text to Numbers for Dates 2
Change Date Format to Specific Text Format When Copying 3
Date Time formatting problem 7

Back
Top