Displaying every 1st and 15th of the month based on todays date

So I have a formula to display the 1st and the 15th of each month going horizontally

=DATE(YEAR(E2),IF(DAY(E2)=1,MONTH(E2),MONTH(E2)+1),IF(DAY(E2)=1,15,1))

where E2 is =TODAY()

However, if =TODAY() isn't 1 or 15, it skips to the 1st of next month. ie. =TODAY() is 1/3/13 - so my formula displays 2/1/13... it should be 1/15/13 and then 2/1/13, 2/15/13, 3/1/13, 3/15/13 etc...
if I need to display a different formula in E3 (where the formula is) just to get that, that's fine...I can't figure out how to to make =IF(DAY(E2)=1,15,1) encompass more than 1 day.

Thanks!

Originally Posted by ConneXionLost

Do you mean like this?

Please Login or Register  to view this content.

quite

Thanks.... I think I tried that backward. I had >=15 in the last function but never got anywhere.

This works!

Originally Posted by tigeravatar

Alternate,

Please Login or Register  to view this content.

This method is new to me, but also functions perfectly. Thanks

another one.

=IF(DAY(A1)<15,A1-DAY(A1)+15,EOMONTH(A1,0)+1)