I have below problem. I am looking to solve the problem in B using A. In B, i want to use date to look through the month Jan08 to Jan09. If Jan08 is blank, i want this to skip and look through to pick Jan09. Same applies to other month if blank skip and look through the next 12months

• A

Jan08 Feb008...Dec08 Jan09 Feb09....Dec09

01/03/2007 Blank 23
02/03/2007
03/03/2007
04/03/2007

• B

Jan09 Feb09....Dec09

01/03/2007 23
02/03/2007
03/03/2007
04/03/2007