Calculating averages - Excel 2002
You're welcome. Thanks for the feedback!
--
Biff
Microsoft Excel MVP
"Peter" wrote in message
...
Brilliant Biff, it worked a treat!
Many thanks
Peter
-------- Original Message --------
Try this...
=G3/(MONTH(NOW())+IF(MONTH(NOW())<3,10,-2))
Where the month numbers would be:
Jan = month 11
Feb = month 12
Mar = month 1
Apr = month 2
..
Dec = month 10
|