JeroenBroek
August 16th, 2007, 03:50 AM
Dear all,
I'm having trouble creating a formula for the count of year-totals.
I have a daterange from january 1st 2006 till august 1st 2007.
The intention is to compare the totals of 2006 and 2007 but use the data from the same months in both years. So september '06 to december 2006 should be left out of the count of 2006.
Anyone have any idea?? Been working on thsi problem for days now, but with no succes at all.
Thanx in advance.
Jeroen
I'm having trouble creating a formula for the count of year-totals.
I have a daterange from january 1st 2006 till august 1st 2007.
The intention is to compare the totals of 2006 and 2007 but use the data from the same months in both years. So september '06 to december 2006 should be left out of the count of 2006.
Anyone have any idea?? Been working on thsi problem for days now, but with no succes at all.
Thanx in advance.
Jeroen