Jan-08 2 1
Jan-08 3 2
Jan-08 4 3
Jan-08 7 4
Jan-08 8 5
Jan-08 9 6




Problem is:-

I have a spreadsheet from A1 TO DG600

In the cells I have either a 1 or L

The A column is the dates for 2 years going down from Jan 2008 until 31 Dec
2009, column B is the actual day.

All the dates represent a working day throughout the year minus weekends and
bank holiday's.

What I need to do it delete on 02 Jan 2009 anything that is in those cells
on that is in row on 02 Jan 2008, leaving the 03 Jan 2008 until we reach 03
Jan 2009. As each day passes then the corresponding cell contents are
deleted. So if I only open it once every few days it will delete the
previous corresponding date the year before, thus having a rolling year. I
have tried to use a macro, but my macro writing is not up to scratch, in
fact I would put it as impossible for me. Is there any chance I can use a
simple formula for this.

I don't want to sound if I'm begging but I have been trying for the past 10
months on my own without must joy.