This assumes your data is in cells A3:A200. I hope you find it helpful.=SUMPRODUCT(--(TODAY()-$A$3:$A$200>=0),--(TODAY()-$A$3:$A$200<=30),--($A$3:$A$200<>"")) =SUMPRODUCT(--(TODAY()-$A$3:$A$200>30),--(TODAY()-$A$3:$A$200<=60),--($A$3:$A$200<>"")) =SUMPRODUCT(--(TODAY()-$A$3:$A$200>60),--(TODAY()-$A$3:$A$200<=90),--($A$3:$A$200<>"")) =SUMPRODUCT(--(TODAY()-$A$3:$A$200>90),--(TODAY()-$A$3:$A$200<=120),--($A$3:$A$200<>"")) =SUMPRODUCT(--(TODAY()-$A$3:$A$200>120),--($A$3:$A$200<>""))
Bookmarks