Sri,
I didn't fully understand your conditions but I think you need
something like this:

in G1: =IF(OR(E1="",C1="")," ",IF(F1-E115,"LATE",""))

(if E1 or C1 are blank, then G1 is blank, otherwise is LATE if difference of
dates is 15)

Or if by 'C1 column is fed' you mean the literal "fed" then

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

Hope this helps.

"srikant_shetty" wrote:


Hi,

Here I need a help from you guys, I planned to create a sheet in that
example: C1 = Received file, E1=completion of maintenance, F1=Current
date and G1=Remarks.

If the E1=20-12-2005 and the F1=Today() and if F1 i.e. Current date is
15 days more thatn the E1 i.e. Completion date then it should display
"LATE" and if it is not less that 15 days then it should display blank
and also there are 2 condition that, if in the E1 column nothing date
is there then it should not show any no. of days. So please if anybody
can help me.

And also if in the C1 column is fed then it should not show LATE in the
remarks column.

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