DanielK2012
New Member
- Joined
- Nov 14, 2014
- Messages
- 8
Hi I am really struggling.
I have a training spreadsheet with circa 2000 dates in and i need to keep track of the following 3 things:
•Total valid certificates
•Total certificates within 1 month of expiry
•Total expired certificates
I already have conditional formatting to show which ones are expiring and color codes them accordingly but i need in the top of the spreadsheet a sort of table with the Count function which will count the above.
Is there any way i can do this.
For reference: Cells B8 to AA150 all contain dates.
I just need to know how to write the CountIF formulae (if that is the correct one) to take into account the month.
I though it would be something like
=countif(B8:AA150,<TODAY()) - For expired certificates
=countif(B8:AA150,>TODAY+Month? - For certificates expiring within the month
=countif(B8:AA150,>TODAY+2month? - for valid in date certificates?
PLEASE HELP


I have a training spreadsheet with circa 2000 dates in and i need to keep track of the following 3 things:
•Total valid certificates
•Total certificates within 1 month of expiry
•Total expired certificates
I already have conditional formatting to show which ones are expiring and color codes them accordingly but i need in the top of the spreadsheet a sort of table with the Count function which will count the above.
Is there any way i can do this.
For reference: Cells B8 to AA150 all contain dates.
I just need to know how to write the CountIF formulae (if that is the correct one) to take into account the month.
I though it would be something like
=countif(B8:AA150,<TODAY()) - For expired certificates
=countif(B8:AA150,>TODAY+Month? - For certificates expiring within the month
=countif(B8:AA150,>TODAY+2month? - for valid in date certificates?
PLEASE HELP


