Re: dates as percentages

Days remaining =A2-TODAY()
% remaining =(A2-TODAY())/(A2-A1)
--
David Biddulph

"minimoi" <minimoi@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:EB2924E9-4D8A-43A0-9AEE-26E23E78BD8F@xxxxxxxxxxxxxxxx
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.


.

Relevant Pages

  • Re: Jaegers 5" f/5 Achromat on ebay (ends Sat 4:56pm pacific)
    ... > limits generally considered okay here, but apologies to anyone who is ... I bought one of these 5" f/5's from Jaegers way back when and like it ... the cell, which made things easy. ...
    (sci.astro.amateur)
  • Optima batteries
    ... When I bought the AGM batteries for my boat, ... to the cell bundles should promote better cooling. ...
    (rec.boats.cruising)
  • 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)
  • Re: dates as percentages
    ... "David Biddulph" wrote: ... "minimoi" wrote: ... cell a2 = 21/06/2011 Shelf life ... days that have already passed since bought in and show one ...
    (microsoft.public.excel.misc)
  • dates as percentages
    ... I really need to make a calculator out of excel to calculate a percentage""" ... cell a2 = 21/06/2011 Shelf life ... days that have already passed since bought in and show one ...
    (microsoft.public.excel.misc)