Hi,

Are you saying you have 2 dates in B10 and you want to check that a10 is
between these dates?

If you do have 2 dates in B10 how are they arrived at because if you do have
2 dates in the cell and you have typed them then a comparison is a lot more
complicated than it need be.

Mike

"Yossy" wrote:

If cell A5 C5 = then Yes, otherwise No, But before it gives Yes it should
look at date (Cell A10 and compare with cell B10) cell A10 must be with the
B10 date.

A10 = 10/17/2008

B10 = (10/1/2008 - 10/31/2008)

All help totally appreciated. Thanks