I am trying to compare a date that I input with a date range to determine
seasonal pricing. This is the formula I used.
=IF(AND((C454/15),(C4512/1)),68,74). I suspect I need to change the date
format. Is that the case? And if so, could you please provide and example.