LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 29
Default Comparing two columns of dates

I'm working in Excel 2007.

I have two columns of dates, the first being a "buy" date and the second
being a "sell" date for the item in that row. If the data is valid, obviously
each date in the second column should be later than the corresponding date in
the first column.

I'd like to create a function that will compare each date in the first
column to the adjacent date in the second column, and tell me if the data is
valid or if there is a date-pair in which the "buy" date falls after the
"sell" date. I don't need this comparison returned for each pair, I just need
to check the columns as a whole and get a "VALID" OR "INVALID" value.

I'm thinking that this needs to be some sort of composite function, maybe
involving a COUNTIF(), but I just can't figure out how to work it.

Thanks for the help!
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Comparing Dates in 4 Columns - Nested Formulas? foofoo Excel Discussion (Misc queries) 2 October 11th 07 10:13 AM
Comparing Dates in 4 Columns - Nested Formulas? foofoo Excel Discussion (Misc queries) 1 October 11th 07 09:39 AM
Comparing Dates fubdap Excel Discussion (Misc queries) 3 September 27th 07 03:53 PM
Comparing two columns of information with 2 new columns of informa cbuck Excel Discussion (Misc queries) 1 January 16th 07 09:49 PM
Comparing dates Debbie F Excel Worksheet Functions 7 September 7th 05 11:57 AM


All times are GMT +1. The time now is 03:30 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"