Hi,
Still I am having the problem I am not getting the correct m
requirements. Now as per your last reply, in my G1 column it is no
showing LATE display at all.
Once again I will repeat my requiements:
I am using 9 columns in a sheet as below:
A1 : Area code
B1 : Blank PPM Sheet to Section
C1 : Received filled PPM from Section
D1 : To section after feeding
E1 : Received corrected PPM from sction
F1 : Maintenance completed date
G1 : Reamrks
H1 : Current Date

What I want is,

1) If we have not sent the PPM sheet to any section i.e. when B1 i
blank, then all column should be blank only.

2) If when B1 is fed (i.e. date) and the F1 is fed after completion an
while comparing the H1(current date) with F1(completion date) i.e H1-F
15 days and if C1 is blank then in the G1 it should display "LATE".

3) If when B1 is fed and F1 is fed and C1 is also fed then G1 should b
blank only because as per our condition that we have received the PP
sheets before the 15 days after the completion date in F1 column.

So please help

Thanks,
Sr

--
srikant_shett
-----------------------------------------------------------------------
srikant_shetty's Profile: http://www.excelforum.com/member.php...fo&userid=3002
View this thread: http://www.excelforum.com/showthread.php?threadid=49713