Display different text in a cell, dependant on a date range

note :

steve already give the answer....

h13 will be less than all those dates

say H13 = 1st jan 15
and today is 1st aug 15

H13 is less than all your criteria
its less than
today + 90
today +5

hence the error you are getting

h13+90 < today()

You need a condition for less than 5 days - otherwise you get false
=IF(H13+90<TODAY(),"THIS IS OVER 90 DAYS",IF(H13+30<TODAY(),"Send 30 day reminder",IF(H13+10<TODAY(),"Send 10 Day Reminder",IF(H13+5<TODAY(),"Send 5 Day Reminder", "need something here" ))))

If this is not correct can you
Please upload a sample of your workbook to the forum, Make sure you have removed any private information, remember this is a public forum and so available to anyone
Would like to see an example of your data and also a manual mock up of the expected results you want to achieve.

To attach a file to your post,
click "Go advanced" (next to quick post),
scroll down until you see "manage Attachments",
click that and select "add files" (top right corner).
click "select files" find your file, click "open" click "upload" click 'done" bottom right. click "submit reply"

Once the upload is completed the file name will appear below the input boxes in this window.
You can then close the window to return to the new post screen.

your welcome and thanks for the rep