| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Counting if Date1 is after and Date2 is before another date
First of all, apologies for putting this in a new question
If i have the following dates A B C D E F 1 04/01/2005 17/02/2005 03/04/2005 03/07/2005 3/10/2005 03/01/2006 2 04/01/2005 18/02/2005 * Ans 1 * Ans 2 * Ans 3 *Ans 4 3 05/01/2005 18/02/2005 4 06/01/2005 19/02/2005 5 07/01/2005 20/02/2005 What formula need to be written in cells C2:C5 (*Ans 1 - 4) to give * Ans 1 - Count if A2:A5 is greater than B1 AND B2:B5 is less than C1 * Ans 2 - Count if A2:A5 is greater than B1 AND B2:B5 is less than D1 * Ans 3 - Count if A2:A5 is greater than B1 AND B2:B5 is less than E1 * Ans 4 - Count if A2:A5 is greater than B1 AND B2:B5 is less than F1 Thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Name The Day Of The Date2 | Excel Discussion (Misc queries) | |||
| Counting Date Changes | Excel Discussion (Misc queries) | |||
| Counting Date Changes | Excel Discussion (Misc queries) | |||
| date counting | Excel Worksheet Functions | |||
| excel formula counting date to date in 4 columns | Excel Worksheet Functions | |||
Threaded Mode
