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

Different Functions in One Cell Cancel Each Other Out - How can I fix this? 1
Show value from one cell in another cell if today falls between a date range 5
VBA Coding Help for Beginner 0
Calculate elapsed time excluding specific timeframe 10
Merging cells and formats 8
setting cell values based on a 3rd cell 4
Need Help 4
Countifs with different restrictions 1

Top