software

Hello, Can some one tell me how would I have a date appear in column A1
when any number/data is input in column B1 and so on down the column,
and have like A5 tell me if any A1;A2;A3;A4 has a day past the 7th day
of any date? I don't need a year to display if it matters.

Thank You--
mario
------------------------------------------------------------------------
mario's Profile: www.excelforum.com/member.php...oamp;userid=31116
View this thread: www.excelforum.com/showthread...hreadid=508997If you mean to have each A-cell flag each B-cell for gt; the 7th day of
any month, then in A1 copied down

=IF(DAY(B1)gt;7,quot;After the 7th',quot;quot;)
That does work, but here's what I'm doing, what I'm looking at right now
on my test page.

Every entry will contain a numeral input one for Auto and one for
Manual, for example in D5 amp; D6 (0 to 999)
In C5 amp; C6 I have these formulas =IF(D5gt;0,NOW(),quot;quot;) amp;
=IF(D6gt;0,NOW(),quot;quot;)
*Problem 1)* is if the entry is a 0 it doesn't date due to gt;0, I need
to count the 0 as well

OK that's one

Now in C7 I have =IF(DAY(C6)gt;7,quot;After the 7thquot;,quot;100%quot;) which only
monitors C6.
*Problem 2)* I'd like it to populate with quot;After the 7thquot; if either C5
or C6 dates after the seventh, and quot;100%quot; should they both be on
schedule before the 7th. A compare thing.

Heh, this works, did a cool conditional format that shades C7 Green or
Red depending on, ya know before or after - quot;After the 7thquot; or quot;100%quot;.--
mario
------------------------------------------------------------------------
mario's Profile: www.excelforum.com/member.php...oamp;userid=31116
View this thread: www.excelforum.com/showthread...hreadid=508997Col=CCol=D
Row=57-Feb-060
Row=67-Feb-06999
Row=7100%

Formulas:
C5: =IF(D5gt;=0,TODAY(),quot;quot;)
C6: =IF(D6gt;=0,TODAY(),quot;quot;)
C7: =IF((DAY(C5)lt;=7)*(DAY(C6)lt;=7),quot;100%quot;,quot;After the 7thquot;)

Is this it?
Works great sept' 1 last issue

The dates in C show now no matter what, I need the date to occur only
once 0-999 has been input in the D cells

Thanks so much
Mario--
mario
------------------------------------------------------------------------
mario's Profile: www.excelforum.com/member.php...oamp;userid=31116
View this thread: www.excelforum.com/showthread...hreadid=508997Change C5 to: =IF(LEN(D5),TODAY(),quot;quot;)

and copy to C6.Change C5 to: =IF(LEN(D5),TODAY(),quot;quot;)

Copy C5 to C6

Change C7 to:
=IF(LEN(C5)*LEN(C6),IF((DAY(C5)lt;=7)*(DAY(C6)lt;=7),quot; 100%quot;,IF(LEN(C5) LEN(C6),quot;After
the 7thquot;,quot;quot;)),quot;quot;)
Thanks for your patience, it works.--
mario
------------------------------------------------------------------------
mario's Profile: www.excelforum.com/member.php...oamp;userid=31116
View this thread: www.excelforum.com/showthread...hreadid=508997