Logical test

Hi all im trying to apply a logical test to a number of cells.
With an example below:



A B C Status
Sent Received Sent Received Sent Received
01/02/2009 02/03/2009 03/04/2009 05/04/2009 05/06/2009 07/07/2009 Complete
01/02/2009 02/03/2009 03/04/2009 05/04/2009 Complete
01/02/2009 02/03/2009 03/04/2009 Incomplete


I want the status column to update automatically with ‘complete’ or ‘incomplete’, so in order for it to be complete there must be a received date, however as you can see C may not necessarily be sent, so a suitable formula would take into account that the received column would only need a date if there is a date in the sent column. Does this make sense? And is it possible!? I’ve played around with the AND function, but can’t seem to get it right and to be honest I’m not convinced it’s the right function to use!

Any help would be much appreciated!