Why if my IF AND Statement in Excel not Working?

I am writing and IF AND statement (with multiple conditions) in Excel to generate labels (in col I) to help me track the standing of my project tasks based on two criteria in col G and H. Can't figure out why it isn't working, HELP!

Col "G" has the status of the task : Complete/ Not Complete Col "H" has the due date My formula is in column "I".

I want to Column I to do he following: IF G = "Incomplete" AND H = a date that has passed THEN I = OVERDUE IF G = "Incomplete" AND H = a date within 1 months THEN I = CRITICAL IF G = "Incomplete" AND H = a date within three months THEN I = ATTENTION

This is the formula I tried (and some other variations with no success)

=IF(AND(G7="Not Complete",H7>TODAY()),"OVERDUE",IF(AND(G7="Not 
Complete",H7>=TODAY()-30),"CRITICAL",IF(AND(G7="Not 
Complete",H7>=TODAY()-90),"ATTENTION","")))

It does not return anything (I am a newbie so not sure what to do next)