Count Dates held in different Tab

[MrCat]

Hi All,
Some fields are empty in the column, but I want to only count the fields with a date in this second tab.

Tab 1 has the formula
Tab 2 has the data in column C, the data being dates which I need to have the total number of cells which have a date in.

So I'm thinking it'll be something like this:

=COUNTIF((ISNUMBER('Tab2'!$C:$C)))

Thanks in advance!

 

[MrCat]

I've decided to use =COUNTA('TAB2'!C2:C)

But if anyone has any better suggestions please let me know!

 

[Joe4]

Understanding the Excel really stores dates as numbers (specifically, the number of days since 1/0/1900), you can use:

=COUNTIF('TAB2'!C:C,">0")

Just bear in mind that if you have other numbers in column C, it will count them too.