Hi all,

In a very old spread sheet i was using this formula
=IF(OR(AND($D7<G$6,$E7F$6),AND(F$6=$D7,F$6<=$E7) ),".","") and it worked for
dates pre 2009. However, i now wish to use it for dates between 2010 - 2011.
Each column represent a week and the rows will indicate and project or task.

can anyone help?