I have a list of dates in short date format (mm dd yyyy) I need a formula that will count the number of dates that are for the previous Month and for current month.
I thought I needed to use =Eomonth(now()). Threre appears so many ways to calculate dates. What is the most efficient way to count previous and current dates