Hi,

I have a table that I have created and I have the following problem:

In column 1, I put the date. Lets say 8/2/2013.
In column 2, I want excel to display August if the date falls between August 1 to August 14, and display September if the date falls between August 15th to August 31st.

I have tried everything from =if to =count if, however I just am stumped and I don't know what to do.

If anyone has any ideas I would really appreciate your help.


I have tried =IF(DAY(B4)<15,"mm/yy","LATE"), however it just displays "mm/yy" if the date I entered in B4 is less than 15th. AAHHH I don't know what to do (((((