I am trying to get a cell to display a message based on the date. I know that
if I was in that particular cell, it could be done easily;

=IF((A6Sheet2!A14),,Sheet2!A15)

where A6 is a given date, Sheet2!A14 is a 'checking' date which changes and
Sheet2!A15 is the message I want displayed if FALSE.

This is fine, but what I want to do is to get the formula to display my
message in another cell. Something along the lines of;

=IF((A6Sheet2!A14),,Sheet1!B14=Sheet2!A15)

Obviously the above doesn't work though.