Shelf Life Percentage

  • Thread starter Thread starter John
  • Start date Start date
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
 
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
 
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
Click to expand...
 
hi
i want to calculate shelf life in percentage biscuits manufactured on 09/08/2021and expiry date 31/08/2021
 
Back
Top