Is a date in summer or winter?
Maybe something like
=IF(C45="","",IF(AND(C45DATE(2007,4,15),C45<DATE( 2007,10,16)),68,74))
--
Regards,
Peo Sjoblom
"Thea" wrote in message
...
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.
|