Shelf Life Percentage

J

John

I've been playing with this, but can't get it to work.

I have a product that has a 10 year shelf life. I'd like a spread sheet
that users can open that will calculate the percentage that is left, based
on "Today's date".

I've tried this.

A1 - 7-Jul-2000 (Entered as date)
A2 - 7-Jul-2010 (Entered as date)
A3 - =A2-A1" gives me 3652
A4 - =Today()

And now I'm stuck. Tried a few different things, but I'm getting further
away instead of closer.

Any and all help gratefully appreciated.

TIA
John
 
S

Sandy Mann

John,

A3 is the number of days in the 10 year period.

A2-A4 is the number of days remaining in the period so

=(A2-A4)/A3 formatted as percentage is what you are looking for.

--
HTH

Sandy
(e-mail address removed)
Replace@mailinator with @tiscali.co.uk
 
J

John

WOOHOO!!

Thanks, that works like a charm.

John

John,

A3 is the number of days in the 10 year period.

A2-A4 is the number of days remaining in the period so

=(A2-A4)/A3 formatted as percentage is what you are looking for.

--
HTH

Sandy
(e-mail address removed)
Replace@mailinator with @tiscali.co.uk
 
Joined
Sep 20, 2021
Messages
1
Reaction score
0
hi
i want to calculate shelf life in percentage biscuits manufactured on 09/08/2021and expiry date 31/08/2021
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top