I am trying to devise a formula that will calculate the number of times a specific numerical day (10th, 11th, etc.) occurs in a column of dates (mm/dd/yy). File attached. Thanks!
I am trying to devise a formula that will calculate the number of times a specific numerical day (10th, 11th, etc.) occurs in a column of dates (mm/dd/yy). File attached. Thanks!
Enter formula in G3 and copy down
Formula:Please Login or Register to view this content.
***Array formula must be entered by using key combination of CTRL+SHIFT+ENTER and not just ENTER
If you like my answer please click on * Add Reputation
Don't forget to mark threads as "Solved" if your problem has been resolved
"Nothing is so firmly believed as what we least know."
--Michel de Montaigne
Try with SUMPRODUCT:
=SUMPRODUCT(--(DAY($A$2:$A$12)=F3))
Quang PT
Both solutions worked great! Thanks!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks