If statement with date

[BCsehi]

I have dates in col A. In col B, I want to write an IF statement that says:
=if(A1<2/11/13,Jan,Feb). I know that this is not a valid formula and I get a NAME error. Can someone help me write the statement correctly? Thanks!

 

[Scott Huish]

Based on what it looks like you are trying to do, perhaps:

=IF(MONTH(A2-10)=1,"Jan","Feb")

or

=IF(A2<("2/11/13"+0),"Jan","Feb")

 

[Scott Huish]

If you want to continue that format for every month:

=TEXT(MONTH(A2-10)*29,"mmm")

 

[Rick Rothstein]

I have dates in col A. In col B, I want to write an IF statement that says:
=if(A1<2/11/13,Jan,Feb). I know that this is not a valid formula and I get a NAME error. Can someone help me write the statement correctly? Thanks!

You could try this (note the use of quote marks... the 1* is to convert the date text into a real date)...

=IF(A1<1*"2/11/14","Jan","Feb")

 

[BCsehi]

I copied your formula (changed the 2/11/14 to 2/11/13), and copied the formula down and I get Feb for all dates even those with 1/23/13 dates???

 

[BCsehi]

My mistake. It works! I put in a wrong reference...

Thanks!

 

[BCsehi]

Thanks for your help. I think I have it licked!!

 

[Rick Rothstein]

Thanks for your help. I think I have it licked!!

Great! Sorry about the 14 for 13 typo... not sure how that happened, but I am glad you saw through it and corrected for it.