Counting Number of Times Dates Appear In Excel Cell within Month/15DAYS/7DAYS

You can use VBA to get the desired output easily without any complex array formula.

Place the following code on a Standard Module and then use it on the sheet like below...

Please Login or Register  to view this content.

and then copy it across and down.

Please note that the cells B1:D1 are custom formatted as "Last "General" Days" so that 30 in B1 will display as "Last 30 Days" etc.

Please Login or Register  to view this content.

Hi,
Thanks for helping me out. I have some quick questions about this solution as I am not excel expert so:

1) Does this VBA Work as the current date changes on my PC daily? Would the results update itself automatically with respect to current date?
2) What if the data (Dates) is present in some other column lets say E.G column I, would that code work accordingly?
3) I don't understand this point "Please note that the cells B1:D1 are custom formatted as "Last "General" Days" so that 30 in B1 will display as "Last 30 Days" etc." . What do you mean by that?

Please don't quote whole posts, especially when you are responding to the one immediately preceding your own - it's just clutter. It's OK to quote if you are responding to a post out of sequence, but limit quoted content to a few relevant lines that makes clear to whom and what you are responding. Thanks!

For normal conversational replies, try using the QUICK REPLY box below.