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(D50,NOW(),"") &
=IF(D60,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%".


--
mario
------------------------------------------------------------------------
mario's Profile: http://www.excelforum.com/member.php...o&userid=31116
View this thread: http://www.excelforum.com/showthread...hreadid=508997