I have a spreadsheet in which I want to make a choice of "A" or "B" based on a set of dates - i.e.,


If today is >4/30/current year and <12/1/current year, choose "A" else choose "B"


Is there a way to write a formula for this?


Thank you, Thank you, Thank you - in advance