Dates between cells in one column and another

  • Thread starter Thread starter excelitous
  • Start date Start date
E

excelitous

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
 
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
 
assuming date in column B is larger than date in column A always:

try

=IF(B1-A1<84,"less than 12 weeks","")
 
assuming the date in column B is always greater than column A, try:

=if(B1-A1<84,"less than 12 weeks","")
 
Back
Top