I have 2 tables of dates in the format DD-MM-YYYY.I want to compare the 2 set
of dates to find out which dates are preceding the others.

=IF(A1<B1,"A1 is the earlier date","B1 is the earlier date")

"Babi" wrote:

> I have 2 tables of dates in the format DD-MM-YYYY.I want to compare the 2 set
> of dates to find out which dates are preceding the others.

Hi,

This is a little unclear. Which dates precede which dates? I will assume
that you are comparing the first cell of the first table to the first cell of
the second table.

Suppose table1 starts in cell A1 and table2 starts in cell H1, you can enter
the formula =A1-H1
If the result is positive A1 is later than H1. If not, the other way
around. If you want to get fancier you could use conditional formatting.
Select the cell you want to compare, A1, and choose Format, Conditional
Formatting, pick Formula is from the first drop down and enter the formula
=A1-H1>0
Click the click the Format button and choose a color on the Patterns tab.
Click OK once and then click Add
From the first drop down for this second condition pick Formula is, and
enter the formula
=A1-H1<0
Format this condition with a different color.
You can copy this format to all the cells in the first table and every cell
will be color coded to indicate if it is before or after the other cell
datewise. If no color appears the date are the same.
Modify the above as needed.


--
Thanks,
Shane Devenshire


"Babi" wrote:

> I have 2 tables of dates in the format DD-MM-YYYY.I want to compare the 2 set
> of dates to find out which dates are preceding the others.

> I have 2 tables of dates in the format DD-MM-YYYY
> I want to compare the 2 set of dates
> to find out which dates are preceding the others

Real dates are just numbers, hence you should be able to just Data > Sort to
taste. If it doesn't respond to sort, then the dates are not real dates
recognized by Excel. In which case, you can try using Data > Text to Columns
to convert it all at one go (ie the col(s) of "dates") to real dates. In step
3 of the wizard, check "Dates", then select the appropriate date format (eg:
DMY) for the data.
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:19,500 Files:362 Subscribers:62
xdemechanik
---