=IF(AND(A4="4/12/2006",A4<="9/12/2006"),"49")

Try it as:
=IF(AND(A4=--"4/12/2006",A4<=--"9/12/2006"),49)
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Michell Major" wrote:
=IF(AND(A4="4/12/2006",A4<="9/12/2006"),"49")

This should show next week as 'Week 49' but doesn't. I want to add another
three IF to this string so that I can get the month sorted out in Week order?