Date Based on Percentage

[rayray72]

Hello,

I am having a hard time trying to create what I think should be a simple formula. Given the scenario below, I am trying to get a date for when a disk will reach 90%. I am using the shown formula in B5 for a date when it will reach 100%(full), but I keep failing trying to get a date for 90%.

Basically, I have a 1000 size disk that has 200 left as of 1/1/2022, with a monthly increase of 20, at what date will 90% of disk size (900) be reached?

There is no start date, and the monthly Increase can fluctuate over time, so I am trying to achieve a 90% date from the "Free Space as of:" date.

Thank you in advance!

 

[arthurbr]

Perhaps

= B4+(0.9*A2-B2)/20

and format as required

 

[steve the fish]

Try this:

=EDATE(B4,(90%*A2-A2+B2)/C2)

 

[steve the fish]

This will only give full months though. Months arent really suitable for this type of calc. You should work out average amount per day then make the calc from that. Days are fixed length. Months are not.

 

[rayray72]

Try this:

=EDATE(B4,(90%*A2-A2+B2)/C2)

This will only give full months though. Months arent really suitable for this type of calc. You should work out average amount per day then make the calc from that. Days are fixed length. Months are not.

That did the trick. Calculated a daily increase and modified your formula, works perfectly!! Thank you so much!!!!!!