Excel date month help

[sunshne900]

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 (((((

[Miraun]

=IF(DAY(A1)<16,"September","August")
?

[sunshne900]

Hi Miraun,
Yes, however how do I have excel determine by itself which month it should display.

=if(day(A1)<15,display the current month, if date is after 15th display next month)

Thank you for the fast reply

[Jonmo1]

Try

=TEXT(DATE(YEAR(A1),MONTH(A1)+(DAY(A1)>14),1),"mm/yy")

[Miraun]

Ohh... I didn't get that from your earlier question... I thought it was specific to August/September

=TEXT(IF(DAY(A1)<15,MONTH(A1),MONTH(A1)+1)*30,"mmmm")

Give that a shot... turns out the mmmm text format pulls the day... so multiply by 30 gives a consistent month measurement.

[sunshne900]

THANK YOU SO MUCH!!!!!!

This works perfectly, I really appreciate it, I was so confused.

[Jonmo1]

Also

=TEXT(A1+IF(DAY(A1)>14,28,0),"mm/yy")

[sunshne900]

What if I need it to do display as 1/1/13?

as in if the first date is, for example, 1/5/13, in the next column because it is before the 15th of the month, I want it to automatically write 1/1/13??
And if it is after the 15th, 1/15/13, I want it to show 2/1/13.

The second column must show only 1, as in 1/1/13, 2/1/13, 3/1/13....etc