Cell contents

[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

 

[John]

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

 

[David Biddulph]

=IF(COUNT(A1,B1)=2,B1-A1,"your error message")

 

[John]

Perfect guys thanks

regards

John

=IF(COUNT(A1,B1)=2,B1-A1,"your error message")

 

[John]

Your Welcome
Regards
John