+30 days from today

Good evening.
Im currently making a spreadsheet for training and i want to add a formula so that if a date in one cell is within 30 days of todays date then it populates another cell with 1 of 3 other cells depending on date?
So todays date is in cell D6
due Date of training is in cell I16
and i want cell J16 to show cell X3 if date before todays date
or
and i want cell J16 to show cell X4 if date within the next 30 days
or
and i want cell J16 to show cell X2 if date is over 30 days from todays date

Sorry im am self teaching this excel lol
Thanks Chris

Give this formula a try...

=IF(I16<D6,X3,IF(I16<D6+30,X4,X2))

Ahh that works great thanks. What about if i wanted to copy the colour off the cell to?

Ahh never mind i sussed it out.. Cheers

Originally Posted by Rick Rothstein

Give this formula a try...

=IF(I16<D6,X3,IF(I16<D6+30,X4,X2))

Yeah that worked great. Now what about if i also want to add to that if J16 =Y then I16 Will show X1 cell instead of X2 ,X3 or X4 cell?

I am not exactly clear on what you are asking. Your original question was for a formula in cell J16 that looked at the contents of cell I16. Your new question is for a formula in cell I16 that looks at the content in I16... which is the reverse of your original question. If you have asked your question correctly, you cannot do that... a cell can contain only one thing, either a constant value or a formula, but not both. Please clarify.