Vmarkup help

[sgrew]

I have a table, as part of an assesment task i am doing, with dates, and a course fee.
Part of the assesment task is to write a formula, to work out how many days in advance the customer paid, and then apply the needed discount.

I found a previous thread but cant seem to get that formula to work.

I have attached what i have so far

Thanks heeps