Hi
I have names in Column A
Date of birth in Column B
I want to count number of people who have dob in Jan,feb......december
Hi
I have names in Column A
Date of birth in Column B
I want to count number of people who have dob in Jan,feb......december
For January DOBs try
=SUMPRODUCT((MONTH(B2:B1000)=1)*(B2:B1000<>""))
change the 1 to 2, 3 etc. for other months
Audere est facere
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks