compare 2 tables of dates to find the preceding dates

B

Babi

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.
 
S

ShaneDevenshire

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.
 
M

Max

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
---
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top