| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
display number if date is in a range
I have a column of starting dates with a second column of dates 60 days after
first, in a third column I have a event date. I need to count row if event happens within the 60 days of first column. 10/15/09 12/14/09 12/1/09 1 10/15/09 12/14/09 12/15/09 0 10/25/09 12/24/09 11/15/09 1 10/13/09 12/22/09 11/1/09 1 Thank you |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
display number if date is in a range
Try this:
=--AND(C2=A2,C2<=B2) Copy down as needed -- Biff Microsoft Excel MVP "lmarty" wrote in message ... I have a column of starting dates with a second column of dates 60 days after first, in a third column I have a event date. I need to count row if event happens within the 60 days of first column. 10/15/09 12/14/09 12/1/09 1 10/15/09 12/14/09 12/15/09 0 10/25/09 12/24/09 11/15/09 1 10/13/09 12/22/09 11/1/09 1 Thank you |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
display number if date is in a range
Count of rows....
=SUMPRODUCT((A1:A4<=C1:C4)*(B1:B4=C1:C4)) If this post helps click Yes --------------- Jacob Skaria "lmarty" wrote: I have a column of starting dates with a second column of dates 60 days after first, in a third column I have a event date. I need to count row if event happens within the 60 days of first column. 10/15/09 12/14/09 12/1/09 1 10/15/09 12/14/09 12/15/09 0 10/25/09 12/24/09 11/15/09 1 10/13/09 12/22/09 11/1/09 1 Thank you |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
display number if date is in a range
Maybe this...
=A1+60C1 -- Rick (MVP - Excel) "lmarty" wrote in message ... I have a column of starting dates with a second column of dates 60 days after first, in a third column I have a event date. I need to count row if event happens within the 60 days of first column. 10/15/09 12/14/09 12/1/09 1 10/15/09 12/14/09 12/15/09 0 10/25/09 12/24/09 11/15/09 1 10/13/09 12/22/09 11/1/09 1 Thank you |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
display number if date is in a range
Sorry, you wanted 0 and 1, not FALSE and TRUE. Try this formula instead...
=--(A1+60C1) -- Rick (MVP - Excel) "Rick Rothstein" wrote in message ... Maybe this... =A1+60C1 -- Rick (MVP - Excel) "lmarty" wrote in message ... I have a column of starting dates with a second column of dates 60 days after first, in a third column I have a event date. I need to count row if event happens within the 60 days of first column. 10/15/09 12/14/09 12/1/09 1 10/15/09 12/14/09 12/15/09 0 10/25/09 12/24/09 11/15/09 1 10/13/09 12/22/09 11/1/09 1 Thank you |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
display number if date is in a range
=--(C1=MEDIAN(A1,B1,C1))
-- David Biddulph lmarty wrote: I have a column of starting dates with a second column of dates 60 days after first, in a third column I have a event date. I need to count row if event happens within the 60 days of first column. 10/15/09 12/14/09 12/1/09 1 10/15/09 12/14/09 12/15/09 0 10/25/09 12/24/09 11/15/09 1 10/13/09 12/22/09 11/1/09 1 Thank you |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Input a number to not display as a date | Excel Discussion (Misc queries) | |||
| Function to find/display the date X number of days later? | Excel Worksheet Functions | |||
| Display Text from Date Range | Excel Discussion (Misc queries) | |||
| How to display date as week number | Excel Discussion (Misc queries) | |||
| Simple Question, display only part of a date in Number format | Excel Worksheet Functions | |||
Linear Mode
