If you want to count dates between to specified dates, you can use countifS(). However, if some of those dates are hyperlinked, and others not, I know of no regular formula that will be abke to tell the difference.

Formulas work on what the cell displays (generally), and not on what the cell contents are (formulas etc)

For instance, assume you have a cell (A1) that contains =10*10 It will display 100, if you used =left(A1,2) you would get 10, not =1...it is reading the 1st 2 characters of the answer, not the cell contents

Hope that helps?