Hi can any one help me. I need to find out which dates within one column are
less than 12 weeks apart from dates in another column.
For example:

Column A 12/03/2009 14/03/2009
Column B 14/04/2009 16/06/2009
I have two columns with 2000 records in and need to identify these records

Try something like this...

=IF(B1<A1+(12*7),"Less","")

--
Biff
Microsoft Excel MVP


"excelitous" <(E-Mail Removed)> wrote in message
news:E262489A-3F6F-4959-AFB5-(E-Mail Removed)...
> Hi can any one help me. I need to find out which dates within one column
> are
> less than 12 weeks apart from dates in another column.
> For example:
>
> Column A 12/03/2009 14/03/2009
> Column B 14/04/2009 16/06/2009
> I have two columns with 2000 records in and need to identify these records

A 'week' is not well defined; but if you mean a week as any 7 days (not a
calendar week) then
=IF(B1-A1>7*12,"More than 12 weeks","less")
will work
You can put anything within the quotes.
If you want a blank rather than "less", use
=IF(B1-A1>7*12,"More than 12 weeks","")
best wishes
--
Bernard Liengme
http://people.stfx.ca/bliengme
Microsoft Excel MVP

"excelitous" <(E-Mail Removed)> wrote in message
news:E262489A-3F6F-4959-AFB5-(E-Mail Removed)...
> Hi can any one help me. I need to find out which dates within one column
> are
> less than 12 weeks apart from dates in another column.
> For example:
>
> Column A 12/03/2009 14/03/2009
> Column B 14/04/2009 16/06/2009
> I have two columns with 2000 records in and need to identify these records

I'm not sure what you want to do when you find items that are less than or
more than 12 weeks, but, you can try this

=IF(B1-A1<=84,"Less than 12 weeks","More than 12 weeks")

If cell B1 minus A1 is less than or equal to 84 (number of days in 12
weeks), then display "less than 12 weeks". Otherwise, display "More than 12
weeks"

This assumes that all of these columns contain date info. You could also do
this with Conditional formatting to change the color of the cell when it
exceeds 12 weeks

"excelitous" wrote:

> Hi can any one help me. I need to find out which dates within one column are
> less than 12 weeks apart from dates in another column.
> For example:
>
> Column A 12/03/2009 14/03/2009
> Column B 14/04/2009 16/06/2009
> I have two columns with 2000 records in and need to identify these records

assuming date in column B is larger than date in column A always:

try

=IF(B1-A1<84,"less than 12 weeks","")
--
hope to help,
cm


"excelitous" wrote:

> Hi can any one help me. I need to find out which dates within one column are
> less than 12 weeks apart from dates in another column.
> For example:
>
> Column A 12/03/2009 14/03/2009
> Column B 14/04/2009 16/06/2009
> I have two columns with 2000 records in and need to identify these records

assuming the date in column B is always greater than column A, try:

=if(B1-A1<84,"less than 12 weeks","")
--
hope to help,
cm


"excelitous" wrote:

> Hi can any one help me. I need to find out which dates within one column are
> less than 12 weeks apart from dates in another column.
> For example:
>
> Column A 12/03/2009 14/03/2009
> Column B 14/04/2009 16/06/2009
> I have two columns with 2000 records in and need to identify these records