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
[email protected]
Replace@mailinator with @tiscali.co.uk
"John" <[email protected]> wrote in message
news:[email protected]...
> 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
Bookmarks