Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Shelf Life Percentage
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
try this
=IF(A1TODAY(),0,IF(TODAY()=A2,1,(TODAY()-A1)/(A2-A1))) "John" wrote: 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 |
#4
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formatting percentage signs in Excel | Excel Discussion (Misc queries) | |||
Help with function to add percentage to cell based on checkbox. | Excel Worksheet Functions | |||
Percentage of overall attendance | Excel Discussion (Misc queries) | |||
percentage of production against quotation | Excel Discussion (Misc queries) | |||
percentage of sales | Excel Worksheet Functions |