dates as percentages

I think you will need to use a few cells to do this... Hopefully someone will post a better way than this.

First, you need to figure out the total number of days between the purchase date and expiry date. In a cell (C2), simply type: =sum(B2-A2).
[use the cells where your end date and beginning dates are located]
[format the third cell as number, not date]

Next, you need to find out how many days are between today and the expiry date. In another cell (C3), type: =sum(B2-TODAY())
[again, format this cell as number]

In a third cell type =C3/C2
[format this cell as percentage]

I tried this out as I typed and it worked. I'm sure there is a better way to do it, and now I am curious to learn!

Good luck!

come to think of it, there is a better way...
in the cell where you want the percentage, type:

Please Login or Register  to view this content.

format the cell as a percentage, and you are done!

my brain is slow today... sorry

Cheers!

Percentage of Shelf life since brought in;

Please Login or Register  to view this content.

Formatted as %
Days remaining

Please Login or Register  to view this content.

Is that what you are looking for?