Help with formula calculating an expiry percentage between two calendar dates

[Tommo1989]

Hi all, first post here I have been racking my brains with this formula and hopefully you can help!

So I am running a stock list with products that have a manufacturing date and a expiry date.

I need formula that calculates between them dates as 100% and then decreases as time goes on.

If it runs past the expiry to show 0%, because in most cases we can get the product recertified thus changing the the dates which then in turn will change the percentage as well.

Can this be done?

Any advise would be a massive help as some of our customers require a certain percent of shelf life to accept the product, so this would make my life a lot easier!

Hope this makes sense

Many thanks

[Kaper]

Assuming your dates are excel real dates in cells A1 (manufactured) and B1 (expiry ) you could use in C1:

Please Login or Register  to view this content.

and format cell C1 as percents

to check if A1 and A2 are real dates try to change these cells format to short/long date and chech if their content is diplayed as short/long dates

[Tommo1989]

Kaper... thank you!

This has worked a treat and is going to help me massively.

Thank you very much indeed.

[Kaper]

Glad to hear it worked,

It would be a good idea to mark this thread as Solved. Above your first post you will find Thread Tools to do it.

Best,