Hi all,
I have this formulawhich counts how many dates it finds this current month.![]()
=COUNTIFS(D1:D3,">="&EOMONTH(TODAY(),-1)+1,D1:D3,"<="&EOMONTH(TODAY(),0))
I'm trying to figure out how to edit this so i can use it to count for all dates last month. And then i'll need another that counts dates from 2 months ago, but i'm sure i could work that out once i have a code for last month.
Any ideas?
Stuart
Bookmarks