Excel Formula (Urgent need in 4 hours) - Schoudhary1553

I have a table of invoices which show a weekly fee and a date from - date to. Dates are given in column headings and a correct formula shows the daily rate for the date in the rows above. When the range is converted to a table the formula does not work. The formula needs to work when the range is converted to tables and this needs to be explained.