software

Hi, I am trying to use a box where notes amp; 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(AK9lt;1,LEFT(T9,2)=quot;:0quot;),MID(T9,2,6)-5gt;$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.

When you format the cell(s) click on quot;customquot; (were you have it set as
quot;generalquot;)
then just type in yymmdd in the small box above the list of custom formatting.

quot;nastechquot; wrote:

gt; Hi, I am trying to use a box where notes amp; a Date are kept.
gt; Looking for the best way to setup, not good at dates
gt;
gt; cell formated as general, If a date is present it will be as:
gt; :yymmdd or 060510
gt;
gt; had cond. format eq like:
gt; IF(AND(AK9lt;1,LEFT(T9,2)=quot;:0quot;),MID(T9,2,6)-5gt;$T$7),
gt;
gt; where T9 is the text cell working in, for future date is within 5 days of a
gt; cell where was trying to put todays date $T$7, e.g.: 060101
gt; Is there a text variable have to apply, guesse would rather not have to use
gt; a separate cell for todays date. PS the face you see in my equation is not
gt; fred.
gt; Its barney. thanks in advance.

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..

quot;NUMBnutquot; wrote:

gt; When you format the cell(s) click on quot;customquot; (were you have it set as
gt; quot;generalquot;)
gt; then just type in yymmdd in the small box above the list of custom formatting.
gt;
gt; quot;nastechquot; wrote:
gt;
gt; gt; Hi, I am trying to use a box where notes amp; a Date are kept.
gt; gt; Looking for the best way to setup, not good at dates
gt; gt;
gt; gt; cell formated as general, If a date is present it will be as:
gt; gt; :yymmdd or 060510
gt; gt;
gt; gt; had cond. format eq like:
gt; gt; IF(AND(AK9lt;1,LEFT(T9,2)=quot;:0quot;),MID(T9,2,6)-5gt;$T$7),
gt; gt;
gt; gt; where T9 is the text cell working in, for future date is within 5 days of a
gt; gt; cell where was trying to put todays date $T$7, e.g.: 060101
gt; gt; Is there a text variable have to apply, guesse would rather not have to use
gt; gt; a separate cell for todays date. PS the face you see in my equation is not
gt; gt; fred.
gt; gt; Its barney. thanks in advance.