Distributing Cost over multiple years based on start and end date

Hi,
I am attempting to distribute costs (column A) in a table across years shown in columns D through M based on the start and end dates in columns B and C. So for example, a project starting in 2022 and ending in 2023 would split the cost evenly between column D and column E for 2022 and 2023.
I have written the formulas seen in row 2 and 3, columns D to M. Row 2 uses cell references and row 3 uses table references. I have tested in a regular spreadsheet without a table and the cellular reference formula works. it seems to be failing to recognize the header dates in columns D to M correctly. When I evaluate both formulas, they calculate correctly but return a false match for the year in the header so return a 0. Can anyone provide a solution?
Attaching a sample with rows 1 to 5 showing the formulas in a table and not working and rows 13 and 14 showing date outside a table and formula working.
Thanks,
Mark