I'm not good with math functions at all, but I've searched for a while and couldn't find anyone even touching on this subject.
I'd like to have the price of $900 slowly approach $1500 between the dates of April 1st and August 1st. That's about $5 per day, and the formula would be:
ROUND(1500 - (600 * ((DEADLINE - TODAY) / (DEADLINE - START)))
Thanks for any help you're able to provide.