Date Percentage Formula Help

Nicole J

I need help with a formula. I have two date-formatted columns ("Archives Start Date" and "Archives End Date") and I need a formula that displays essentially "as of today, we're X% of the way between those two dates".

Any help is greatly appreciated.

Leibel S

@Nicole J

Try this:

=IF([Archive End Date]@row > [Archive Start Date]@row, MAX(MIN((([Archive End Date]@row - [Archive Start Date]@row) - ([Archive End Date]@row - TODAY())) / ([Archive End Date]@row - [Archive Start Date]@row), 1), 0), "End Date is before Start Date")

Leibel S

@Nicole J

Try this:

=IF([Archive End Date]@row > [Archive Start Date]@row, MAX(MIN((([Archive End Date]@row - [Archive Start Date]@row) - ([Archive End Date]@row - TODAY())) / ([Archive End Date]@row - [Archive Start Date]@row), 1), 0), "End Date is before Start Date")

Nicole J

Leibel,

Thanks for your help. This worked like a charm.