This discussion is archived
5 Replies Latest reply: Aug 21, 2013 10:36 AM by JDN RSS

HFR ISSUE FOR MONTHS

991847 Newbie
Currently Being Moderated

Hi Every body,

 

I  have scenario like

 

If it is mar2011 in first column(My pointer current point of view)

 

mar----apr--May----Jun-----Jul-----Aug---Sep-----Oct----Nov----Dec----Jan----feb---Mar

2011-2011-2011--2011--2011--2011-2011---2011----2011----2011---2012---2012--2012

 

I have used range function and RELATIVE FUNCTION FOR CHANGING THE MONTHS

 

IHAVE TAKEN ONLY  TWO COLUMNS IN MY REPORT FIRST COLUMN MAR AND NEXT COLUMN BY USING RANGE&RELATIVE FUNCTION OF CURRENT MONTH

 

BUT YEAR IS THE PROBLEM IT S NOT UPDATING.

HOW SHOULD I UPADATE YEAR ACCORDING TO THE MONTH

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points