Certificates!
Member
I have a workbook with three worksheets for every week, so by now, almost six months into the year, there are lots of worksheets.
I want to count the number of times a worksheet is less than 3 months old. The date is in cell B3.
I know that I can use =COUNTIF('Sheet1'!B3,TODAY()-1)+COUNTIF('Sheet2'!B3,TODAY()-1) etc, but that is cumbersome. Is there a formula I can use that will count the number of sheets where cell b3 is less than 1 month ago?
Thank you.
I want to count the number of times a worksheet is less than 3 months old. The date is in cell B3.
I know that I can use =COUNTIF('Sheet1'!B3,TODAY()-1)+COUNTIF('Sheet2'!B3,TODAY()-1) etc, but that is cumbersome. Is there a formula I can use that will count the number of sheets where cell b3 is less than 1 month ago?
Thank you.