Hi,
In A2:A1000 in Sheet1 I have series of consecutive month-end dates (31/07/2012, 31/08/2012 etc).
In A2:A700 in Sheet2 I have a series of consecutive month-end dates and in B2:B700 the associated monthly sales values.
In A2:A700 in Sheet3 I have a series of consecutive month-end dates...