Check multiple dates in range

HI,

I want to have a formula to check if the start date and finish date are correct.

For it to be correct, the start date (for example on Strategic) on P50 should be equal or less than the P50 and start date of P50 should be equal or less than start date of P90. Similarly, P50 finish date should be more or equal to base finish date and P90 finish date should be more or equal to the P50 finish date.

This should also accordingly apply for the dates of concept, delivery readiness delivery and finalisation.


How can we set up formula for this?

For it to be correct, the start date (for example on Strategic) on P50 should be equal or less than the P50 and start date of P50 should be equal or less than start date of P90

Is this written correctly? It seems you left out some words. I'm assuming you mean that the start date of P50 for Strategic must be >= start date of Base for Strategic and <= P50 for Strategic of P90.
What if they're not?

To start things off, next to your P50 start date for Strategic, something like:
=IF(AND(C38>=C12,C38<=C71),"","Problem here")

kvsrinivasamurthy,
Data validation can't be used as the dates are pre-populated so, need a formula to check if the date have been entered right OR NOT.

Thanks Gregb11,
It seems to do what I wanted.

Now, I have got five formulas which return null values (assuming that they are all true) or some "Problem Here"

How, do I get using an array or otherwise check to ensure if any is null value or some of them return "Problem Here"

I'm not understanding. Maybe if you could upload a file to exhibit what you're saying. What does this mean?

How, do I get using an array or otherwise check to ensure if any is null value or some of them return "Problem Here"