Thread: Excel 2007 - calculating % of a year that has elapsed
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
John John is offline
external usenet poster
  
Posts: 2,069
Default Excel 2007 - calculating % of a year that has elapsed
How do I calculate what percentage of a year has elapsed?
I have the date 31/12/09 in cell A1 and the date 31/05/09 in cell B1 and
then I do this: =B1/A1*100 but this formula is wrong.How should I do the
calculation?
Thanks, John

Reply With QuoteReply With Quote