| Home |
| Search |
| Today's Posts |
|
#6
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-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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| HOW CREATE FORMULA TO ADD THE COLUMN CELLS THAT CONTAINING DATES | Excel Worksheet Functions | |||
| how do I sort a column of random dates into Consecutive dates | Excel Worksheet Functions | |||
| Count number of cells of a particular month in a column of dates | Excel Discussion (Misc queries) | |||
| How do I count cells in a column of dates between date ranges? | Excel Worksheet Functions | |||
| Count cells in a column that contain dates | New Users to Excel | |||
Threaded Mode
