Date the input, then tell if over 7th off month

[mario]

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

[just_jon]

If you mean to have each A-cell flag each B-cell for > the 7th day of
any month, then in A1 copied down

=IF(DAY(B1)>7,"After the 7th',"")

[mario]

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 & D6 (0 to 999)
In C5 & C6 I have these formulas =IF(D5>0,NOW(),"") & =IF(D6>0,NOW(),"")
Problem 1) is if the entry is a 0 it doesn't date due to >0, I need to count the 0 as well

OK that's one

Now in C7 I have =IF(DAY(C6)>7,"After the 7th","100%") which only monitors C6.
Problem 2) I'd like it to populate with "After the 7th" if either C5 or C6 dates after the seventh, and "100%" 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 - "After the 7th" or "100%".

[just_jon]

Col=C Col=D
Row=5 7-Feb-06 0
Row=6 7-Feb-06 999
Row=7 100%

Formulas:
C5: =IF(D5>=0,TODAY(),"")
C6: =IF(D6>=0,TODAY(),"")
C7: =IF((DAY(C5)<=7)*(DAY(C6)<=7),"100%","After the 7th")

Is this it?

[mario]

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

[just_jon]

Change C5 to: =IF(LEN(D5),TODAY(),"")

and copy to C6.

[just_jon]

Change C5 to: =IF(LEN(D5),TODAY(),"")

Copy C5 to C6

Change C7 to:
=IF(LEN(C5)*LEN(C6),IF((DAY(C5)<=7)*(DAY(C6)<=7),"100%",IF(LEN(C5)+LEN(C6),"After
the 7th","")),"")

[mario]

Thanks for your patience, it works.
But today the 8th, the C5 & C6 dates changed without input and my comparison in C7 went to "After the 7th"

I'm figuring if I use NOW rather than TODAY in C5 & C6 that should eleviate that, I'm going to test that now.
UPDATE-Unfortunatly NOW also updates the next day as well. would like to some how use an automatic keystroke CTRL+; so there is no formula that updates automatically.

But I know a question or concern that will arise is that a person next month can re-enter the data in D5 or D6 before the 7th and turn their previous months Late input to "100%", would need to prevent the re-entering of a recorded line as well.