I have attached a table I am trying to work from, I need to produce a report for the quarter periods based on the data in the summary sheet (date added / date deleted).
If a vehicle was either added or deleted between X dates (quarter periods) I need it to be copied accross to the appropriate sheet i.e
Line 5 = 1st Quarter (date deleted - 30/01/2009)
Line 6 = Would need to appear in the 2nd & 3rd Quarter (date added - 11/05/2009 (2nd Q) date deleted - 20/07/2009 (3rd Q))
Line 7 = 2nd Quarter (date added - 17/02/2009 / date deleted - 18/02/2009)
Lines 8 & 9 = Not appear anywhere until a date had been inserted against it
Line 10 = 1st Quarter (date added - 01/01/2009 / date deleted - 02/01/2009)
Line 11 = Not appear anywhere until a date had been inserted against it
Line 12 = 2nd Quarter (date deleted - 08/05/2009)
Line 13 = Would need to appear in the 2nd & 3rd Quarter (date added - 14/05/2009 (2nd Q) date deleted - 18/08/2009 (3rd Q))
I have tried using IF statement but not sure if I should be using some form of LOOKUP formula.
Also in column 'G' I have the word 'inception'. Would this effect any formula in any way?
Bookmarks