formula for due date in correlation to today's date

[thedethman]

hi i need a few formulas to do slightly different things.

firstly i have

i need to calculate date due, is it due in 30 days, is it due in a week and is it due over due.
so far i have my work book values as:

D1 how often item is checked in months (manually imputed)
E1 checked by someone else
I1 date item was cheched (manually imputed and formated as date dd/mm/yy)
J1 is next due date with formula =EDATE(I1,D1)

works fine up to here then i have 3 formulas all of which stay blank if I1 is blank and also:

if check is due in 30 days or less (couldn't figure out month) but if was done by someone else reads YES (book in A.S.A.P.) instead of yes =IF(J1="","",IF(TODAY()>=(J1-30),IF(E1="YES","YES (book in A.S.A.P.)","yes"),"no"))

if check is due in 7 days or less =IF(I1="","",IF(TODAY()>=J1-7,"YES","no"))

if check is due/overdue. =IF(I1="","",IF(TODAY()>=J1,"YES","no"))

im sure it's something simple i keep missing but its got me stumped please help.

if your read this whole thing thank you, you if have an answer big thank you

[FDibbins]

Hi, welcome to the forum

It would probably be easier to see what you want if you could upload a small (clean) sample workbook (not a pic) of what you are working with, and what your expected outcome would look like.

[thedethman]

i figured out what happened. the formula was fine i was just using date that were before due date instead of after it. like i said "i'm sure its something simple i keep missing".

too little coffee too many spread sheets

thanks anyway.

[FDibbins]

Im happy yoyu fixed your problem, and thanks for sharing the "fix"