Update Percent Progress Automatically Based on Two Dates?

[Mouser-IB-Admin]

I'm not sure if I'm looking for a formula or if what I'm wanting is even possible, so this is just a general question about utilizing the progress functionality for percent fields.

What I'm hoping to accomplish is a percent field, set to view as progress, that updates based on the progress between two date fields. So for example, if date 1 (0%) is January 1st, 2024 and date 2 (100%) is December 31st, 2024, I'm wanting the percent progress to update as the year progresses to show as it gets closer to date 2.

The progress function is great but if it were able to automatically update for tasks that have start/end dates that would make it all the more powerful. Is this possible?

[TheTimeSavingCo]

Yeap it is, check this base out

You'll probably need to add more error checks though, right now I'm only checking whether today is before the end date and after the start