Work out if date is more than 6 days ahead

[sharky12345]

I'm using this formula to work out if a date is in the past or future;

=IF(ISBLANK(D10),"",IF(D10<TODAY(),"Not Valid",IF(D10>TODAY(),"Future","Valid")))

I need to take it one step further though - can I include if the date in the future is more than 6 days ahead? If it can be done I need it to show "Too Far".

Thank you!

 

[RoryA]

You mean this?

=IF(ISBLANK(D10),"",IF(D10>TODAY()+6,"Too far",IF(D10>TODAY(),"Future","Valid"))))

 

[sharky12345]

Perfect, thanks Rory!