I spotted this in a questions and want to know what the dashes are for. I
have also seen dashes used in the SUMPRODUCT function. This is copied &
pasted to show entire question/answer

QUESTION:
=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?

ANSWER:
Try it as:
=IF(AND(A4=--"4/12/2006",A4<=--"9/12/2006"),49)