|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
November 16th, 2009, 04:53 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
Dates between cells in one column and another
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 
|
|
#2
November 16th, 2009, 05:11 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
Dates between cells in one column and another
Try something like this...
=IF(B1A1+(12*7),"Less","") -- Biff Microsoft Excel MVP "excelitous" wrote in message ... 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
|
|
#3
November 16th, 2009, 05:14 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
Dates between cells in one column and another
A 'week' is not well defined; but if you mean a week as any 7 days (not a
calendar week) then =IF(B1-A17*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-A17*12,"More than 12 weeks","") best wishes -- Bernard Liengme http://people.stfx.ca/bliengme Microsoft Excel MVP "excelitous" wrote in message ... 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
|
|
#4
November 17th, 2009, 05:23 AM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
Dates between cells in one column and another
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
|
|
#5
November 17th, 2009, 05:54 AM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
Dates between cells in one column and another
assuming date in column B is larger than date in column A always:
try =IF(B1-A184,"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
|
|
#6
November 17th, 2009, 05:59 AM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
Dates between cells in one column and another
assuming the date in column B is always greater than column A, try:
=if(B1-A184,"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
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
