Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do I keep the date from changing format in a mail merge? | Excel Discussion (Misc queries) | |||
format date in excel | Excel Discussion (Misc queries) | |||
Why Does Date Format Change on Chart | Excel Discussion (Misc queries) | |||
How do I keep the date from changing format in a mail merge? | Excel Discussion (Misc queries) | |||
Opening a csv file with US date format on a Australian PC | Excel Discussion (Misc queries) |