One way
=if(SUMPRODUCT(--(TEXT(LDatein,"mmyy")=TEXT($FM$4,"mmyy"))*(LPilot= "SPB"))0,1,"")--Don GuillettMicrosoft MVP ExcelSalesAid "Excel 2007 - SPB" wrote in ...I have the following formula =SUMPRODUCT(--(TEXT(LDatein,"mmyy")=TEXT($FM$4,"mmyy"))*(LPilot= "SPB")) Ldatein is a column with a date entry, FM4 is a date, LPilot is a 3 letterid This works fine, but How do I "Count" dates ONCE i.e. two entries on 6/1 would only count 1 entry. Thanks for any help SPB