Calculate % complete with Date Range and Today's date
I need a formula to return % Complete based on a start - end date range and today's date.
So for example:
Date Range: 06/18/23 - 06/30/23
Today's date: 06/26/23
As there are 12days in this date range, and today's date is day 8 out of 12, the percentage complete would be 66.6%
Thanks in advance!
Help Article Resources
Check out the Formula Handbook template!