If and then

Hi I am trying to use the if function.


I have the criteria from A2. then trying to make an output in B2. I was trying to make a date range in my sheet.

so, what i have in mind it to make an output like ,"If A2 is equals to "02/01/2013, then display Week1.

Responses will be a great help.

Thanks! Ae

Hello, thank you for your prompt response. I really appreciate it.

I have another concern if it's not too much to ask.

Let say,

I put in dates between feb 1,2013 to feb 07 in A2 then the output should say "week1" in b2
If I put feb 8, 2013 to feb 20, it should display "week 2".
same goes for the upcoming dates as week 3 and week 4.

responses will be very much appreciated