Cell contents

J

John

Hi,
In Cell A1 and B1 there are dates, cell C1 calculates the difference between
these dates and displays it as days.
How can I have a function in cell C1 which will notify me if there are any
dates not entered. i.e. "Date Required" or "incorrect Format"

Regards

John
 
J

John

Hi John
Maybe something like this : =IF(OR(A1="",B1=""),"Date Required",B1-A1)
HTH
John
 
Top