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?

There is nothing it that formula that will make it work for pre-2009 and not
for later years.
Perhaps you need to look at your data values?
If you have a problem, you could tell us what values are being fed into the
formula when it works for you, what the values are when it doesn't work, and
in that case, what result it gave and what you expected.
--
David Biddulph


"Scott_goddard" wrote in message
...
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?