Hi All,
I am completely stumped on how to do this and would really appreciate your help. Basically, I have a product which is being continuously produced. The quantity produced is different each day. The product is used up in a first in first out method. I need a formula to accurately predict the age (in days) of the oldest product remaining after it is used as the product expires after a certain length of time. This is a link to a worksheet demonstrating the problem I am having: https://1drv.ms/x/s!Amw_zEKvGX8fhZ0Z37Aq10wizly9Mg The " Age (correct values)" represents what I want my formula to return.
I'd really appreciate it if you guys had some ideas on this.
Thanks!
I am completely stumped on how to do this and would really appreciate your help. Basically, I have a product which is being continuously produced. The quantity produced is different each day. The product is used up in a first in first out method. I need a formula to accurately predict the age (in days) of the oldest product remaining after it is used as the product expires after a certain length of time. This is a link to a worksheet demonstrating the problem I am having: https://1drv.ms/x/s!Amw_zEKvGX8fhZ0Z37Aq10wizly9Mg The " Age (correct values)" represents what I want my formula to return.
I'd really appreciate it if you guys had some ideas on this.
Thanks!