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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

working out days between date. 6
setting cell values based on a 3rd cell 4
Calculate elapsed time excluding specific timeframe 10
Need Help 4
countifs Function not giving desired result with date criteria 2
text to date..! 3
Difference between two date/time values 5
Comparison of columns using Conditional Formatting 3

Top