Hi all,

So, I'm creating a gantt chart in Excel and it's going OK. The formula
I'm using is:

=IF(AND(C$1>=$A$2,C$1<$B$2),"1","")

C1 is January 1st, D1 is February the first, etc. A2 is the start date
of the project and B2 is the end date. Conditional formatting changes
the cell with one into a green. This is working fine except where a
project starts mid month the formula does not pick it up.

Can anyone suggest what changes I need to make so that the formula will
put a "1" where a project starts mid-month.

TIA,

SamuelT


--
SamuelT
------------------------------------------------------------------------
SamuelT's Profile: http://www.excelforum.com/member.php...o&userid=27501
View this thread: http://www.excelforum.com/showthread...hreadid=544666

Maybe.........
=IF(AND(MONTH(C$1)=MONTH($A$2),C$1<$B$2),"1","")

Vaya con Dios,
Chuck, CABGx3



"SamuelT" wrote:

>
> Hi all,
>
> So, I'm creating a gantt chart in Excel and it's going OK. The formula
> I'm using is:
>
> =IF(AND(C$1>=$A$2,C$1<$B$2),"1","")
>
> C1 is January 1st, D1 is February the first, etc. A2 is the start date
> of the project and B2 is the end date. Conditional formatting changes
> the cell with one into a green. This is working fine except where a
> project starts mid month the formula does not pick it up.
>
> Can anyone suggest what changes I need to make so that the formula will
> put a "1" where a project starts mid-month.
>
> TIA,
>
> SamuelT
>
>
> --
> SamuelT
> ------------------------------------------------------------------------
> SamuelT's Profile: http://www.excelforum.com/member.php...o&userid=27501
> View this thread: http://www.excelforum.com/showthread...hreadid=544666
>
>

Vaya,

There was one little thing missing:

=IF(AND(MONTH(C$1)>=MONTH($A$2),C$1<$B$2),"1","")

Many Thanks,

SamuelT


--
SamuelT
------------------------------------------------------------------------
SamuelT's Profile: http://www.excelforum.com/member.php...o&userid=27501
View this thread: http://www.excelforum.com/showthread...hreadid=544666

You're welcome........glad you figured it out.

Sorry about the type-o, my tongue got in front of my eye-tooth and I
couldn't see what I was saying <g>

Vaya con Dios,
Chuck, CABGx3



"SamuelT" wrote:

>
> Vaya,
>
> There was one little thing missing:
>
> =IF(AND(MONTH(C$1)>=MONTH($A$2),C$1<$B$2),"1","")
>
> Many Thanks,
>
> SamuelT
>
>
> --
> SamuelT
> ------------------------------------------------------------------------
> SamuelT's Profile: http://www.excelforum.com/member.php...o&userid=27501
> View this thread: http://www.excelforum.com/showthread...hreadid=544666
>
>