LinkBack URL
About LinkBacks
Try this formula, it can tolerate blanks in the range and dates in different years
=SUM(IF(FREQUENCY(A2:A100,A2:A100-DAY(A2:A100)),1))
confirmed with CTRL+SHIFT+ENTER
Try this formula, it can tolerate blanks in the range and dates in different years
=SUM(IF(FREQUENCY(A2:A100,A2:A100-DAY(A2:A100)),1))
confirmed with CTRL+SHIFT+ENTER
Audere est facere
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks