Hello All
I work on a huge database that get updated each month with fresh data. The date on this data is captured in MMYYYY format. Now at times i am asked to build a report on a rolling 12 month basis ex. Jul 2017 to June 2018, Jun 2017 - May 2018, May 2017 - Apr 2018 so and so forth. Usually i would be expected to add just the recent 12 months, unfortunately there are chances data in the previous 12 months also may change, so every month i need to undertake this task afresh. Can you please help me with a formula that will identify the latest month and year and tag it as "Year 1" the previous month as "Year 2" for example:
Jul 2017 to June 2018 = Year 1
Jun 2017 - May 2018 = Year 2
May 2017 - Apr 2018 = Year 3
Now when data for July 2018 comes in i need the system to identify this and tag as follows:
Aug 2017 to July 2018 = Year 1
Jul 2017 to June 2018 = Year 2
Jun 2017 - May 2018 = Year 3
May 2017 - Apr 2018 = Year 4
Would be really grateful if anyone could assist.
TIA
I work on a huge database that get updated each month with fresh data. The date on this data is captured in MMYYYY format. Now at times i am asked to build a report on a rolling 12 month basis ex. Jul 2017 to June 2018, Jun 2017 - May 2018, May 2017 - Apr 2018 so and so forth. Usually i would be expected to add just the recent 12 months, unfortunately there are chances data in the previous 12 months also may change, so every month i need to undertake this task afresh. Can you please help me with a formula that will identify the latest month and year and tag it as "Year 1" the previous month as "Year 2" for example:
Jul 2017 to June 2018 = Year 1
Jun 2017 - May 2018 = Year 2
May 2017 - Apr 2018 = Year 3
Now when data for July 2018 comes in i need the system to identify this and tag as follows:
Aug 2017 to July 2018 = Year 1
Jul 2017 to June 2018 = Year 2
Jun 2017 - May 2018 = Year 3
May 2017 - Apr 2018 = Year 4
Would be really grateful if anyone could assist.
TIA