Prev: how to convert amount into text automaticaly in excel
Next: Hiding rows and printing
From: Scott_goddard on 8 Apr 2010 08:44
Hi all,

In a very old spread sheet i was using this formula
=IF(OR(AND($D7<G$6,$E7>F$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?
From: "David Biddulph" groups [at] on 8 Apr 2010 18:14
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" <Scottgoddard(a)discussions.microsoft.com> wrote in message
news:899048F9-DC50-4A81-BA1F-29E74CF43EFC(a)microsoft.com...
> Hi all,
>
> In a very old spread sheet i was using this formula
> =IF(OR(AND($D7<G$6,$E7>F$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?


 | 
Pages: 1
Prev: how to convert amount into text automaticaly in excel
Next: Hiding rows and printing