Dear all,

I have an excel worksheet like the following (there are about 20 cols and 500 rows)

Col h Col I Col J Col k Col L Col M
3/12/2013 Rob 1/2/2014 Susanna 3/3/2014 Tash
8/2/2014 Tash 19/11/2014 colin

Some of the dates has hyperlink associate to it, ie, not all date have hyperlink

Is there a way I can use formular to count number of hyperlink according to user defined time range, say before 1/1/2014, between 1/1/2014 and 30/10/2014, after 30/10/2014. So I may have the following results

before 1/1/2014
Tash 1
Colin 0
Rob 0
Suzanna 3

between 1/1/2014 and 30/10/2014
Tash 22
Colin 7
Rob 90
Suzanna 23



after 30/10/2014
Tash 10
Colin 2
Rob 1
Suzanna 3

Is the above achieveable using formular please?

Thanks in advance.