Microsoft Excel. Shelf life: calculate on which day % left equals 75

Let :

a = expiry date
b = some date
c = manufacturing date

Then :

 (a - b)/(a - c)= 75% = 0.75

Rearrange :

 (a - b) = 0.75 * (a - c)
 - b = (0.75*(a - c)) - a

 b = a - (0.75*(a - c))

So your formula should be :

 some date = expiry date - (0.75*(expiry date - manufacturing date))

Please share if it works/understandable/not. ( :


In my opinion, you may simplify the formula for finding the target date first.

For example, A = manufacturing date, B = expiry date, C = Date at 75% remaining.

Then you could get as following:

(B-C)/(B-A)=0.75

C=0.25*B+0.75A

Then you may use the formula =0.25*B2+0.75*A2 in C2 on my sample, please remember to set the cells with results as Date.

enter image description here