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


[TABLE="class: cms_table_grid, width: 500, align: center"]
<tbody>[TR]
[TD]Time Value[/TD]
[TD]First Period[/TD]
[TD]Second Period[/TD]
[TD]Third Period[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]0-26[/TD]
[TD]27-53[/TD]
[TD]53+[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]0-25[/TD]
[TD]26-52[/TD]
[TD]52+[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]0-24[/TD]
[TD]25-51[/TD]
[TD]51+[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]0-23[/TD]
[TD]24-59[/TD]
[TD]59+[/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD]0-31[/TD]
[TD]32-58[/TD]
[TD]58+[/TD]
[/TR]
[TR]
[TD]6[/TD]
[TD]0-30[/TD]
[TD]31-57[/TD]
[TD]57+[/TD]
[/TR]
[TR]
[TD]7[/TD]
[TD]0-29[/TD]
[TD]30-56[/TD]
[TD]56+[/TD]
[/TR]
[TR]
[TD]8[/TD]
[TD]0-28[/TD]
[TD]29-55[/TD]
[TD]55+[/TD]
[/TR]
[TR]
[TD]9[/TD]
[TD]0-27[/TD]
[TD]28-54[/TD]
[TD]54+[/TD]
[/TR]
</tbody>[/TABLE]
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
[TABLE="class: cms_table, width: 500"]
<tbody>[TR]
[TD]0[/TD]
[TD]1[/TD]
[TD]2[/TD]
[TD]3[/TD]
[TD]4[/TD]
[TD]5[/TD]
[TD]6[/TD]
[TD]7[/TD]
[TD]8[/TD]
[TD]9[/TD]
[TD]10[/TD]
[TD]11[/TD]
[TD]12[/TD]
[TD]13[/TD]
[TD]14[/TD]
[TD]15[/TD]
[TD]16[/TD]
[TD]17[/TD]
[TD]18[/TD]
[TD]19[/TD]
[TD]20[/TD]
[TD]21[/TD]
[TD]22[/TD]
[TD]23[/TD]
[TD]24[/TD]
[TD]25[/TD]
[TD]26[/TD]
[TD]27[/TD]
[TD]28[/TD]
[TD]29[/TD]
[TD]30[/TD]
[TD]31[/TD]
[TD]32[/TD]
[TD]33[/TD]
[TD]34[/TD]
[TD]35[/TD]
[TD]36[/TD]
[TD]37[/TD]
[TD]38[/TD]
[TD]39[/TD]
[TD]40[/TD]
[TD]41[/TD]
[TD]42[/TD]
[TD]43[/TD]
[TD]44[/TD]
[TD]45[/TD]
[TD]46[/TD]
[TD]47[/TD]
[TD]48[/TD]
[TD]49[/TD]
[TD]50[/TD]
[TD]51[/TD]
[TD]52[/TD]
[TD]53[/TD]
[TD]54[/TD]
[TD]55[/TD]
[TD]56[/TD]
[TD]57[/TD]
[TD]58[/TD]
[TD]59[/TD]
[TD]60[/TD]
[TD]61[/TD]
[TD]62[/TD]
[TD]63[/TD]
[TD]64[/TD]
[TD]65[/TD]
[TD]66[/TD]
[TD]67[/TD]
[TD]68[/TD]
[TD]69[/TD]
[TD]70[/TD]
[TD]71[/TD]
[TD]72[/TD]
[TD]73[/TD]
[TD]74[/TD]
[TD]75[/TD]
[TD]76[/TD]
[TD]77[/TD]
[TD]78[/TD]
[TD]79[/TD]
[TD]80[/TD]
[TD]81[/TD]
[TD]82[/TD]
[TD]83[/TD]
[TD]84[/TD]
[TD]85[/TD]
[TD]86[/TD]
[TD]87[/TD]
[TD]88[/TD]
[TD]89[/TD]
[TD]90[/TD]
[TD]91[/TD]
[TD]92[/TD]
[TD]93[/TD]
[TD]94[/TD]
[TD]95[/TD]
[TD]96[/TD]
[TD]97[/TD]
[TD]98[/TD]
[TD]99[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]2[/TD]
[TD]2[/TD]
[TD]2[/TD]
[TD]2[/TD]
[TD]2[/TD]
[TD]2[/TD]
[TD]2[/TD]
[TD]2[/TD]
[TD]2[/TD]
[TD]2[/TD]
[TD]2[/TD]
[TD]2[/TD]
[TD]2[/TD]
[TD]2[/TD]
[TD]2[/TD]
[TD]2[/TD]
[TD]2[/TD]
[TD]2[/TD]
[TD]2[/TD]
[TD]2[/TD]
[TD]2[/TD]
[TD]2[/TD]
[TD]2[/TD]
[TD]2[/TD]
[TD]2[/TD]
[TD]2[/TD]
[TD]2[/TD]
[TD]2[/TD]
[TD]2[/TD]
[TD]9[/TD]
[TD]9[/TD]
[TD]9[/TD]
[TD]9[/TD]
[TD]9[/TD]
[TD]9[/TD]
[TD]9[/TD]
[TD]9[/TD]
[TD]9[/TD]
[TD]9[/TD]
[TD]9[/TD]
[TD]9[/TD]
[TD]9[/TD]
[/TR]
</tbody>[/TABLE]

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