If error datedif statement question

[deezone13]

Hi,

I have a spreadsheet where I need to return a value for files with a due date within the next 7 days as Yes, Past due as "" and dates greater than 7 days return a "Future date"). current formula :

=IFERROR((DATEDIF(TODAY(),M2,"D")<=7),""), brings back Blanks for past due, True for <+7 days, False for +8 days.

Please tell me how I can return "Yes" for <=7Days, and "Future Date" for +8 days.

Pretty sure just a nested if, and I have tried multiple times with different results but closest I come is the way it is now. but I have not been able to get it to work.

Thank you for your assistance.

 

[Eric W]

Welcome to the forum.

Maybe:

=IF(M2-TODAY()<0,"",IF(M2-TODAY()<=7,"Yes","Future Date"))

 

[deezone13]

Yes sir that does work, and now I am wondering why I didn't do a nested if in the first place, Hmmm. Thanks for the assistance.

 

[Jonmo1]

Looks like you already have solution, but just FYI

Datedif was erroring (therefor trapped by iferror and returing "") because it expectes the 2nd date (M2) to be Equal to or Greater than The 1st date (Today)