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