Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Date Format problem
Hi, I am trying to use a box where notes & a Date are kept.
Looking for the best way to setup, not good at dates cell formated as general, If a date is present it will be as: :yymmdd or 060510 had cond. format eq like: IF(AND(AK9<1,LEFT(T9,2)=":0"),MID(T9,2,6)-5$T$7), where T9 is the text cell working in, for future date is within 5 days of a cell where was trying to put todays date $T$7, e.g.: 060101 Is there a text variable have to apply, guesse would rather not have to use a separate cell for todays date. PS the face you see in my equation is not fred. Its barney. thanks in advance. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Date Format problem
When you format the cell(s) click on "custom" (were you have it set as
"general") then just type in yymmdd in the small box above the list of custom formatting. "nastech" wrote: Hi, I am trying to use a box where notes & a Date are kept. Looking for the best way to setup, not good at dates cell formated as general, If a date is present it will be as: :yymmdd or 060510 had cond. format eq like: IF(AND(AK9<1,LEFT(T9,2)=":0"),MID(T9,2,6)-5$T$7), where T9 is the text cell working in, for future date is within 5 days of a cell where was trying to put todays date $T$7, e.g.: 060101 Is there a text variable have to apply, guesse would rather not have to use a separate cell for todays date. PS the face you see in my equation is not fred. Its barney. thanks in advance. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Date Format problem
Hi, I don't always ask the question right, else maybe would know answer?
anyways, I need to find a number within text, so I can perform a calculation on it, thanks.. "NUMBnut" wrote: When you format the cell(s) click on "custom" (were you have it set as "general") then just type in yymmdd in the small box above the list of custom formatting. "nastech" wrote: Hi, I am trying to use a box where notes & a Date are kept. Looking for the best way to setup, not good at dates cell formated as general, If a date is present it will be as: :yymmdd or 060510 had cond. format eq like: IF(AND(AK9<1,LEFT(T9,2)=":0"),MID(T9,2,6)-5$T$7), where T9 is the text cell working in, for future date is within 5 days of a cell where was trying to put todays date $T$7, e.g.: 060101 Is there a text variable have to apply, guesse would rather not have to use a separate cell for todays date. PS the face you see in my equation is not fred. Its barney. thanks in advance. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Date format default problem | Excel Worksheet Functions | |||
format date in excel | Excel Discussion (Misc queries) | |||
Why Does Date Format Change on Chart | Excel Discussion (Misc queries) | |||
format the "date" button for a header | Excel Discussion (Misc queries) | |||
How to format a date to a different format | Excel Discussion (Misc queries) |