Thread: Excel 2007 - calculating % of a year that has elapsed
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.newusers
Niek Otten Niek Otten is offline
external usenet poster
  
Posts: 3,440
Default Excel 2007 - calculating % of a year that has elapsed
O yes, and format as %

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"john" wrote in message
...
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