IF I have two dates, can I calculate the % difference between those dates based on today's date? For example if I had 1 Jan 2021 and 31 Dec 2021. If today was 1 July 2021 I would want to return 50%

Assuming Jan 1 is startdate and Dec 31 is enddate: ((today-startdate) / (enddate-startdate))*100.

Thanks, I've got something similar working... ROUND(({today}-{startdate})/({enddate}-{startdate}),1)