IF with multiple Date conditions

[well]

Can someone correct my formula or alternative formula that will solve my problem. This will also help me to learn how to do a multiple conditions by Dates in the future.

Here are my conditions. "J4" is the column where they input the date:
IF J4 = blank (no entry), return blank
IF J4 = Date today, return "Enter in VIPER"
IF J4 - Date today <=6, return "Due Soon"
IF J4 - Date today >=7, return "Due Now"
IF J4 - Date today >=30, return "Completed"

this is the formula I attempted to make but it didn't work:
IF(J4="","",IF((TODAY()=J4),"Enter in VIPER",IF(AND(J4-TODAY()<=6),"Due Soon",
(IF(((J4-TODAY())>=7),"Due Now",(IF(((J4-TODAY())>=7),"Completed"))))).

 

[Sanjeev1976]

Check whether the below formula meets your purpose :

=IF(J4="","",IF(TODAY()=J4,"Enter in VIPER",IF(DAY(J4)-DAY(TODAY())<=6,"Due Soon",
IF(DAY(J4)-DAY(TODAY())>=7,"Due Now",IF(DAY(J4)-DAY(TODAY())>=7,"Completed")))))

 

[well]

for the portion for "completed" is not working "IF(DAY(J4)-DAY(TODAY())>=10,"Completed"
just need to correct instead of 7 it supposed to 10 "IF(DAY(J4)-DAY(TODAY())>=10,"Completed", my mistake

Check whether the below formula meets your purpose :

=IF(J4="","",IF(TODAY()=J4,"Enter in VIPER",IF(DAY(J4)-DAY(TODAY())<=6,"Due Soon",
IF(DAY(J4)-DAY(TODAY())>=7,"Due Now",IF(DAY(J4)-DAY(TODAY())>=7,"Completed")))))

 

[njimack]

Think this is what you're after...

=IF(J4,LOOKUP(J4-TODAY(),{0,6,10,30},{"Enter in VIPER","Due Soon","Due Now","Completed"}),"")

 

[well]

can you be able to fix a little bit for "Enter in VIPER", I want if "0" or same date as J4 is "Enter in VIPER" only, if more than zero or if within 1 to 6 days is "Due Soon".
interesting formula of yours different approach.

Think this is what you're after...

=IF(J4,LOOKUP(J4-TODAY(),{0,6,10,30},{"Enter in VIPER","Due Soon","Due Now","Completed"}),"")

 

[njimack]

can you be able to fix a little bit for "Enter in VIPER", I want if "0" or same date as J4 is "Enter in VIPER" only, if more than zero or if within 1 to 6 days is "Due Soon".
interesting formula of yours different approach.

Slight tweak...
=IF(J4,LOOKUP(J4-TODAY(),{0,1,6,10},{"Enter in VIPER","Due Soon","Due Now","Completed"}),"")

 

[well]

Slight tweak...
=IF(J4,LOOKUP(J4-TODAY(),{0,1,6,10},{"Enter in VIPER","Due Soon","Due Now","Completed"}),"")

Perfect Neil. Interesting approach and it's simple. I learned something new. Appreciated!

Thank on both of you Neil and Sanjeev,
Well

 

[well]

Slight tweak...
=IF(J4,LOOKUP(J4-TODAY(),{0,1,6,10},{"Enter in VIPER","Due Soon","Due Now","Completed"}),"")

Perfect Neil. Interesting approach and it's simple. I learned something new. Appreciated!

Thank on both of you Neil and Sanjeev,
Well