The formula is pretty simple
(Number of 'days' since the highest value - Number of days since the lowest value/ The number of days being examined)
I am thinking of something like:
I haven't got anything to work quiet right.
Thanks for the help!