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

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

--
Biff
Microsoft Excel MVP


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

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

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