View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
minimoi minimoi is offline
external usenet poster
 
Posts: 14
Default dates as percentages

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.