Multiple IF Statements

[rowena229]

Attachment 224009

I am looking for a formula with multiple IF statements to do the following below:

In cell G11, I would like to mark an 'X', if column D says 'Complete' and the date in column E is within the month in columns G-S.

Any help would be greatly appreciated. Thank you.

[rowena229]

The formula I used to have was:

=IF($E11<G1,"",IF($E11>G2,"","x"))

But the above formula only marks an 'X' if column E is within that month.

[judgeh59]

=IF(AND(ColumnD="Complete",StartDate>=BL1,EndDate<=BL2),"X","") - I wasn't really sure about your columns so hopefully you can understand and plug in the cells....maybe next time attach the worksheet, makes it a little easier on the helper side....HTH

[rowena229]

Perfect that worked! Thanks!

[judgeh59]

Glad I could help....