Fill column automatically based on cell value?

[kiralukaslarson]

hello everyone

i tried to calculated life cycle in numerology.so life cycle period filled in cell M35 - DH35 and cells are filled automatically and changed at a certain age based on the Time value (cell D6)
there is 3 period
first Period = result from single digit of month of birth except the numbers 11
second period = result from single digit of date of birth except the number 11, 13,14 16, 19, 22
third period = result from single digit of year of birth except the number 11, 13,14 16, 19, 22
example = 16 November 2038
first period = 11(not reduced)
second period = 16 (not reduced)
third period = 13 ( 2 + 3 + 8)


the birth of date data : MONTH/DATE/YEAR cell D3 , E3, F3
so life cycle period filled in cell M35 - DH35 and cells are filled automatically and changed at a certain age based on the Time value (cell D6)
ex

Time Value	First Period	Second Period	Third Period
1	0-26	27-53	53+
2	0-25	26-52	52+
3	0-24	25-51	51+
4	0-23	24-59	59+
5	0-31	32-58	58+
6	0-30	31-57	57+
7	0-29	30-56	56+
8	0-28	29-55	55+
9	0-27	28-54	54+

<tbody>
</tbody>

example johny Time is 7 and born 9 february 1994 then cell start from M35 - DH35 filled
note : 0-99 /age = in my excel file is cell M15- DH15

0	1	2	3	4	5	6	7	8	9	10	11	12	13	14	15	16	17	18	19	20	21	22	23	24	25	26	27	28	29	30	31	32	33	34	35	36	37	38	39	40	41	42	43	44	45	46	47	48	49	50	51	52	53	54	55	56	57	58	59	60	61	62	63	64	65	66	67	68	69	70	71	72	73	74	75	76	77	78	79	80	81	82	83	84	85	86	87	88	89	90	91	92	93	94	95	96	97	98	99
2	2	2	2	2	2	2	2	2	2	2	2	2	2	2	2	2	2	2	2	2	2	2	2	2	2	2	2	2	2	9	9	9	9	9	9	9	9	9	9	9	9	9

<tbody>
</tbody>

my excel example
https://ufile.io/ro8de