Using IF Function with date ranges from TODAY function

Hi Everyone,

I am new here and I hope someone can help me figure this out please.

I am using IF to give certain answers depending on the input criteria which is prioritised set out in the following:

1. IF H6 has a date in then I6 will return "Complete", If no date next step.

2. IF G6 has a date in the past from TODAY it will return "Late"

3. IF G6 has a date 7 days ahead of TODAY it will return "Imminent"

4. IF G6 has a date that is over 7 days ahead of TODAY it will return "Scheduled"

I have everything working apart from points 3 and 4 it seems to return one of the required answers but not both in the required format.

I have attached an image, which also includes the formula I'm using, to make it easier to see what i am trying to achieve.

Many thanks in advance.

IF(H6>0, "Complete", If(G6 < TODAY(), "Late" ,if(G6 < TODAY()+7 , "Imminent" , "Scheduled")))


I just deleted a few words from your explaination. < may need to be <= I will leave that to you

Thank you davsth that has done the job for the correct wording.

However, it now leaves "Late" if both date cells are blank. I try to use IF ISBLANK but then says I have too many arguments, have you got a solution for that?

Thanks

As you never gave that as a scenario to cover in your question!

Perhaps
if(and(h6="",g6=""),"",IF(H6>0, "Complete", If(G6 < TODAY(), "Late" ,if(G6 < TODAY()+7 , "Imminent" , "Scheduled"))))

Apologies, as I had that bit working I missed it on the description.

Thanks very much for your help though that works brilliantly.