| Home |
| Search |
| Today's Posts |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
find dates between in excel
Excellent!!! Works like a charm! Thank you!!
"Toppers" wrote: Sorry ... my typo .... =SUMPRODUCT(--(A1:A27="BOB"),--(MONTH(B1:B27)=5),--(YEAR(B1:B27)=2007)) "MDI Anne" wrote: This first formula (for month only) works fine...but the second one (for month & year) comes up with zeros only. What am I doing wrong? I copied directly from here to my worksheet.... "Toppers" wrote: this will count of BOB for MAY (month 5) =SUMPRODUCT(--(A1:A27="BOB"),--(MONTH(B1:B27)=5)) For a specific month/year =SUMPRODUCT(--(A1:A27="BOB"),--(MONTH(B1:B27)=5),--YEAR(B1:B27)=2007)) You can replace "BOB" with cell containing the text "BOB" HTH "MDI Anne" wrote: I have 2 columns of data: one is name, the other is dates. BOB 5/1/2007 STEVE 4/19/2007 JOHN 3/22/2007 MARY 7/21/2006 KATHY 5/4/2007 BOB 10/7/2006 STEVE 5/22/2007 MARY 5/14/2007 MARY 3/7/2007 MARY 5/30/2007 KATHY 1/5/2007 JOHN 5/15/2007 BOB 5/25/2007 STEVE 5/13/2007 BOB 5/1/2007 STEVE 4/19/2007 JOHN 3/22/2007 MARY 7/21/2006 KATHY 5/4/2007 BOB 10/7/2006 STEVE 5/22/2007 MARY 5/14/2007 MARY 5/30/2007 KATHY 1/5/2007 JOHN 5/15/2007 BOB 5/25/2007 STEVE 5/13/2007 I'd like to know how many times each name shows up in the month of May (or whatever month I'm looking for). So, if I need a "findbetween" or some other formula, I would love some help. Thanks all, in advance! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Find future dates | Excel Discussion (Misc queries) | |||
| How do I find the earliest dates in a range of dates? | Excel Worksheet Functions | |||
| Excel auto filtering to find a range of dates in a list | Excel Discussion (Misc queries) | |||
| to find number of days between 2 dates using vba code in excel | Excel Discussion (Misc queries) | |||
| Find a "date" in a column of dates in Excel 2000 | Excel Worksheet Functions | |||
Threaded Mode
