Hi I hope you can help me with this one. I have two colmuns of dates and I want to calculate the average difference between those dates IF the first date falls in the last 12 rolling months. EG
Col A Col B 1/1/12 4/1/12 25/5/12 26/5/12 13/3/13 16/3/13 19/4/13 26/4/13 1/5/13 20/5/13
In the example above the formula would calculate that 13/3/13, 19/4/13, 1/5/13 all fall in the last 12 months. It would then say that the differece between them is 3, 7, 19 and so the average is 9.66 days. Ideally this would be one formula in one cell, but it can be over several cells. Is this possible?
Thanks in advance
Bookmarks