| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
count number of dates in a row of cel before or after a variable d
Hi there. I want to create a formula to count the number of dates that fall
before or after a set date. The sheet is structured so that there is a column with the date of an interview, call it 'E'. There are then a number of dates recorded in rows €˜N to €˜AP. I want to create two separate formula that count the number of dates between €˜N and €˜AP that fall before or after the date in €˜E. I tried: €œ=COUNTIF(N2:BR2,N2:BR2<C2)€ but it returns €˜0. Any suggestions? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| count the number of months between two dates | Excel Worksheet Functions | |||
| how to count number of days between 2 dates? | Excel Discussion (Misc queries) | |||
| I want to count the total Number of dates between two dates How? | Excel Worksheet Functions | |||
| In a set of dates, can you count the number of Jan '07 instances? | Excel Worksheet Functions | |||
| Count number of dates | Excel Worksheet Functions | |||
Threaded Mode
