formula to check the date sequence in rows
Assuming you have dates in ColB and ColC with the headers in Row 1; try the
below formula in ColE or any available column.
In E1
=IF(B2C2,"Date not in sequence","")
(copy down as required...)
If this post helps click Yes
---------------
Jacob Skaria
"brenda" wrote:
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
|