|Well thanks to any who read this! I was able to figure it out after I posted this but thought that others may have this issue, so here is the results.|
The outside if statement is to cover February, if this is not done it will work on the 29th cell if it is not a leap year but result in an error on the 30th cell.
Where AL36 is the day before, G4 is the current month.
So if AL36 is the 28th of Feb, 2012, then AL36+1 would be 29-Feb-12 and it would report it out, but if AL36 is the 28th of Feb, 2011 it would be blank.