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.

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.

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.