dates as percentages

From: minimoi <minimoi@xxxxxxxxxxxxxxxxxxxxxxxxx>
Date: Thu, 18 Sep 2008 12:16:03 -0700

I really need to make a calculator out of excel to calculate a percentage"""
example
cell a1 = 19/09/2008 bought in
cell a2 = 21/06/2011 Shelf life
this is the example info, I now need to find out the percentage of time
remaining in date? ie calculate the total amount of days in stock minus the
days that have already passed since bought in (todays date) and show one
result as a percentage and one as days remaining.

Any help would be most appreciated.
.

Follow-Ups:
- RE: dates as percentages
  - From: Mike H
- Re: dates as percentages
  - From: David Biddulph

Prev by Date: Re: close a workbook after 5 minutes
Next by Date: Re: Find Feature and Paste Link
Previous by thread: create a summary page that will take a list and remove empty rows
Next by thread: Re: dates as percentages
Index(es):
- Date
- Thread

Relevant Pages

Re: how do i overwrite a cell and keep adding to another figure?
... I was using the circular refference. ... separate source cell for adding a new total to the original. ... Gord Dibben Excel MVP ... Is there a way i can write the figure bought ...
(microsoft.public.excel.newusers)
Re: how do i overwrite a cell and keep adding to another figure?
... separate source cell for adding a new total to the original. ... Gord Dibben Excel MVP ... overwrite 30 and my new figure is 70 if i edit other cells, ... Is there a way i can write the figure bought ...
(microsoft.public.excel.newusers)
Re: how do i overwrite a cell and keep adding to another figure?
... separate source cell for adding a new total to the original. ... Iterations and set to 1. ... Gord Dibben Excel MVP ... Is there a way i can write the figure bought ...
(microsoft.public.excel.newusers)
Re: how do i overwrite a cell and keep adding to another figure?
... Excel 95 - Excel 2007 ... Is there a way i can write the figure bought ... each time stock for a particular product is bought it is recorded in ... the same cell, ie. the old figure is overwritten, so the 25 is replaced ...
(microsoft.public.excel.newusers)
RE: dates as percentages
... "minimoi" wrote: ... cell a2 = 21/06/2011 Shelf life ... days that have already passed since bought in and show one ...
(microsoft.public.excel.misc)