True/False to Y/N

[JEA]

I have posted another thread earlier but I think I figured it out except now instead of having "Y","N" returned, I get True/False. Is there a way to change back to Y/N?

Here is what I have:

=IF(AND(DATE(2010,9,29)<=L7,L7>=DATE(2011,10,1)),"Y","N")=IF(AND(DATE(2011,10,1)>=L7,L7<=DATE(2011,10,1)),"Y","N")

[NBVC]

Do you mean?

=IF(OR(AND(DATE(2010,9,29)<=L7,L7>=DATE(2011,10,1)),AND(DATE(2011,10,1)>=L7,L7<=DATE(2011,10,1))), "Y","N")

[NBVC]

Thanks for the rep and comments, JEA.

I assume that your thread is solved based on the comments given.

If so, kindly reply to this thread saying that it is solved and mark it as such.

This will be beneficial to future users having similar problem.