Sri,

=IF(E1="","",IF(AND(C1="",F1-E115),"LATE",""))

"srikant_shetty" wrote:


Thanks for your suggestions, but it is not fully completed. The
following are my requirements.
I have planned to make a status report in my office.
In the C1=Received Files (as per the date) e.g.01-01-2006.
E1=Completion Date e.g. 16-01-2006
F1=Current date (TODAY())

My requirements are as follows:
1. If F1-E115 it should display in G1="LATE" only if C1 is blank, if
they have received the file in C1 and they fed the date then it should
not diplay in G1="LATE" instead it should be blank only.
2. If E1 is not fed any dates i.e. it is not completed then once again
in G1 should be blank only.

I think now you understood my problems.

Thanks,
Sri


--
srikant_shetty
------------------------------------------------------------------------
srikant_shetty's Profile: http://www.excelforum.com/member.php...o&userid=30025
View this thread: http://www.excelforum.com/showthread...hreadid=497136