Calculate average

**Ramesh Velu** · 01-28-2013, 05:43 AM

Dear Friends,

Kindly through light for the below scenario,

Imagine that we are in June, and the average should be calculated for JAN - MAY / 5 automatically by recognizing the current month JUN. And subsequently for the following months example if we are in JULY, average should be calculated for JAN - JUNE / 6

JAN FEB MAR APR MAY JUN JULY AUG SEP OCT NOV DEC AVG
10 25 45 87 56 ?

Regards
Ramesh

**Ace_XL** · 01-28-2013, 05:51 AM

Try..

Please Login or Register  to view this content.

**Ramesh Velu** · 01-28-2013, 07:02 AM

Thank you dear Ace, will this change automatically for next month like JAN+FEB/2 ?

Regards
RAMESH

**Ramesh Velu** · 01-28-2013, 07:16 AM

Thank you dear Ace, will this change automatically for next month like JAN+FEB/2 ?

Regards
RAMESH

**Ramesh Velu** · 01-28-2013, 07:58 AM

I checked this formula, hope this works according to system calender but if i change the system calender, the calculation does not change for this formula. Please clarify.

Example: Current month is JAN, so the default calculation is JAN/1 = Average

If I change system calender to FEB, the calculation does not change to JAN+FEB/2 = Average.

Regards
Ramesh