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