Thread
:
Shelf Life Percentage
View Single Post
#
4
John
Posts: n/a
WOOHOO!!
Thanks, that works like a charm.
John
"Sandy Mann" wrote in
:
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
Replace@mailinator with @tiscali.co.uk
"John" wrote in message
...
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
Reply With Quote