Count "ONLY" dates (Today/Tomorrow in filtered view viisable)

All,

First thank you all in advance for all advice.......


I have an excel spreadsheet and it is filtered. while filtered I want to count only the visible DATE for ECD
thinking like today TODAY() and tomorrow TODAY()+1

I am unsure what code to use and count seemed to count even hidden lines while only want visible lines.

This below is my code using to list Total Paperwork | Today ECD | Tomorrow ECD | the code in this one cell and is REF from a (insert shape =$I$2) that shows all the text on it.

(CELL I2)...... ="CURRENT VIEW TOTAL PAPER: - "&SUBTOTAL(3,H6:H1000)&" | ECD TODAY: - "&COUNTIF(U:U, TODAY())&" | ECD TOMORROW: - "&COUNTIF(U:U, TODAY()+1)

Column U is my date column showing 07/30/15 so my code needs = TODAY()


MBCMDR

Edit2 Can you please attach example workbook, it will be easier to work it out. Thanks.

Edit1 Please ignore it, i did not factor filter on different column than date column. It wont work if you filter by column B and dates are in column A


Hi,

You can try this

Please Login or Register  to view this content.

Just change the columns to what you need, there probably is better a way of doing it but this one works (for next day outcome use the same formula but TODAY()+1)