View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Peter[_14_] Peter[_14_] is offline
external usenet poster
 
Posts: 14
Default Calculating averages - Excel 2002

Good evening,

I'm using this formula to calculate monthly averages based on cell G3: =G3/MONTH(TODAY())
and it works fine if the year begins in January.
Is there a way to calculate the average if the year begins in say, March?

Regards