Grid Construction With numeric values & Dates

[writetoevv]

13 3/11/2016	14 4/11/2016	15 5/11/2016	16 6/11/2016	17 7/11/2016
12 2/11/2016	3 24/10/2016	4 25/10/2016	5 26/10/2016	18 8/1111/2016
11 1/11/2016	2 23/10/2016	1 22/10/2016	6 27/10/2016	19 9/11/2016
10 31/10/2016	9 30/10/2016	8 29/10/2016	7 28/10/2016	20 10/11/2016
25 15/11/2016	24 14/11/2016	23 13/11/2016	22 12/11/2016	21 11/11/2016

<tbody>
</tbody>

Hi Friends,

Could you help to create grid like above
In middle cell of 5 by 5 Grid , i will place a random number (ex: 1) along with random date(ex:22/10/2016)
It should Construct the remaining values (in clockwise direction) for other cells automatically using excel formulae..

Appreciate for the help..

 

[writetoevv]

Hi Peter,

Appreciate for all your effort & Time.

Thanks & Regards,
Viswa

PS: I have a vague thought in my mind to further utilise search results .. I am looking for more clarity on my thought.
I will get back to you if I get more clarity on it.. Thanks a Ton

 

[Peter_SSs]

Appreciate for all your effort & Time.

You are welcome.

I will get back to you if I get more clarity on it..

No problem. In the interim, I realise that the previous code does not search correctly as I understand the requirement. For example with the exact same data from post #20, if you now change cell E2 to 8, cells with 8, 18, 28, 38 etc all get highlighted whereas I presume it should only be "8".

The correction would be to change this line

Const CF1 As String = "=OR(FIND($E$2&CHAR(10),A8&$E$2&CHAR(10))=1,ISNUMBER(FIND(CHAR(10)&TEXT($E$3,""dd/mm/yyyy""),A8)))"