Percentage complete formula between two dates

[MV22]

Hello,

I have formula that automatically calculates the percentage of completion on a project between two dates (the start date and end date). The formula I chose to use is: =(DATEDIF(start date column, TODAY(),"d")+1)/(DATEDIF(start date column, end date column, "d")+1).

This has worked well except when the project is complete and ends. For example, start date 11/01/21, end date 11/31/21, and today is 1/17/22 the percent complete shows 260%. How can I make it that so once the project is at 100% completion it stays at that percentage?

Thank you in advance!

 

[Joe4]

Welcome to the Board!

One of the things you can do is wrap your current formula in a MIN function to set an upper limit, i.e.

=MIN(your formula, 100%)

 

[MV22]

Welcome to the Board!

One of the things you can do is wrap your current formula in a MIN function to set an upper limit, i.e.

=MIN(your formula, 100%)

Yes! This worked. Simpler than I thought. Thank you!

 

[Joe4]

You are welcome.
Glad I was able to help!