LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
nastech
 
Posts: n/a
Default Date Format Problems??

Date Format Problems??

Hi, I am a bit novice at some of this; any suggestions will help, (can
find/ using: format cells, number/custom.. cond. format..)

Date example that I was/ am using: Text: 051113, and "Right Justify" to
see just last 2 digits: 13 (for day)
I changed system date format in Control Panel, Regions, to be: yy-mm-dd
(did not really want dashes, trying for database type sorting of dates..?)
Don't know if I should pick a different format to do same thing.. to see:
yymmdd.

- Is there a work-around for seeing "text"? / last two characters of DATE?
When I format as a date, & narrow the column, & Right Justify (for space &
to see just the last 2 numbers), i get: ##
Trying to get ## to go away, and still be a date.


2nd problem: need Function for date older than 1 "Business" day. (for
Cond. Formatting), (note: for weekends-sat / sun, Friday is still today :)
is there a Date type Function to use?, Thanks, need something like:

IF( last "Business" DATE is one day old),true,false)



 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I keep the date from changing format in a mail merge? Brynn Wilson Excel Discussion (Misc queries) 2 February 1st 07 05:19 PM
format date in excel Nigel Excel Discussion (Misc queries) 2 September 15th 05 09:52 PM
Why Does Date Format Change on Chart John Taylor Excel Discussion (Misc queries) 0 September 11th 05 08:16 AM
How do I keep the date from changing format in a mail merge? Brynn Wilson Excel Discussion (Misc queries) 1 June 9th 05 06:44 PM
Opening a csv file with US date format on a Australian PC Troy Lea Excel Discussion (Misc queries) 2 March 16th 05 10:05 PM


All times are GMT +1. The time now is 02:59 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"