IF Statement: After certain dates, retrieve several lines of text

[SOLVED by amromerodiaz]

Hi there,

I'm trying to create a formula that allows me to retrieve several lines of text after certain dates have passed. For instance:

After Jan 1 - "Happy new year"
After Feb 1 - "1 Month in"
After March 1 - "Spring is on"

Now it's Jul 23. I want to see the cell show: Happy new year & 1 Month in & Spring is on

The formula that I have so far is below. The problem is that it only retrieves happy new year. How can I change it to see multiple entries?

(A1 = 23 Jul, B1 = Jan 1, B2 = Feb 1, B3 = Mar 1)

=IF(A1>B1,"Happy new year",IF(A1>B2,"1 Month in",IF(A1>B3,"Spring is on","")))

Thanks for your help!

Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic

If that takes care of your question, please mark your thread as Solved by selecting Thread Tools (just above your first post) --> Mark thread as solved.
Moreover you may also click on * (star) to Add Reputation to those who have put their time and efforts to help you in this forum. This is another way to say thanks to them.