IF THEN Statements

[PKIMBLEY]

I am setting up a workbook for all my employees to tell me if the need training, it is not applicable, or if they are ok. I wrote this logic statement
=IF(H2S!E2="NA","NA",IF(H2S!E2>TODAY(),"OK","NEED"))

and it works great so I thought that if i could get it to tell me when the employess training renewal date was between 0-30days it would be even better. So I wrote this logic statement

=IF(H2S!E2="NA","NA",IF(H2S!E2-TODAY()>=30,"OK",IF(H2S!E2-TODAY()>=0AND<=30,"SOON",IF(H2S!E2-TODAY()<0,"OVERDUE",""))))

this did not work could some one help me or point out where my error is? H2S!E2 is a cell with a Date in it. I hope I explaned my self

[abousetta]

Maybe try this:

Please Login or Register  to view this content.

abousetta

[abousetta]

Also this should work:

Please Login or Register  to view this content.

abousetta

[:) Sixthsense :)]

May be this...

Please Login or Register  to view this content.

Hope that helps!