With your dates in columns B and C and your data starting on row 2...

Enter this formula in E3 and copy down as needed:

=IF(B3=C2+1,"Ok","Not In Sequence")

No error checking for empty cells.

--
Biff
Microsoft Excel MVP


"brenda" wrote in message
...
Hi,
I am checking monthly claims report to ensure that the payment of monthly
benefit is not overlapping. Using the table below, could someone give me
a
formula to check that the payment period from and payment period to is in
the
right sequence.

Monthly Benefit Period from Period to Amount Paid
840.00 26/12/2007 23/09/2008 7,173.33
840.00 24/09/2008 16/12/2008 767.92
840.00 17/12/2008 10/02/2009 503.90

Thanks

Brenda