Formula Help please...

[How_Do_I]

I've lost myself with this formula...

=IF(AND(AG$7>=$L9-DAY($L9)+1,AG$7<=$N9),IF(DATE(YEAR($L9),MONTH($L9),1)<=AG$7,IF($N9>=AG$7,1,0),0),"")

That formula wasn't working until I swopped the value if true and the value if false around...

However what I want is the formula not to calculate when the logical test is false...

So before the change of the value if true and value is false I had:

=IF(AND(AG$7>=$L8-DAY($L8)+1,AG$7<=$N8),"",IF(DATE(YEAR($L8),MONTH($L8),1)<=AG$7,IF($N8>=AG$7,1,0),0))

What should I use to have "" as value if true WHEN the logical test isn't true... Does that even make sense...!

 

[AlphaFrog]

=IF(AND(AG$7>=$L9-DAY($L9)+1,AG$7<=$N9),IF(DATE(YEAR($L9),MONTH($L9),1)<=AG$7,IF($N9>=AG$7,1,0),0),"")

I'm not sure I follow what you are shooting for. Your formula has three IF statements. The last two seem to duplicate what the first IF(AND already does.

This is a guess; Try something like this...

=IF(AND(AG$7>=$L9-DAY($L9)+1,AG$7<=$N9), 1, "")

 

[How_Do_I]

=IF(AND(AG$7>=$L9-DAY($L9)+1,AG$7<=$N9), 1, "")

I've lost my way with the formula.... This seems to be working though but I'm not sure about the IF statements myself...

=IF(AND(AG$7>=$L8-DAY($L8)+1,AG$7<=$N8)=FALSE,"",IF(DATE(YEAR($L8),MONTH($L8),1)<=AG$7,IF($N8>=AG$7,1,0)))

 

[How_Do_I]

In Cell L8 downwards I have a start dates which aren't always the start of the month... In Cell N8 downwards I have end dates... Starting in AG7 I have month and year going across... I'm creating a GNATT Chart (think that's the name)...