Is a date in summer or winter?

[Guest]

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((C45>4/15),(C45>12/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.

 

[Peo Sjoblom]

Maybe something like

=IF(C45="","",IF(AND(C45>DATE(2007,4,15),C45<DATE(2007,10,16)),68,74))

 

[Bob Phillips]

=IF(AND(C45>DATE(YEAR(C45),4,15),C45<DATE(YEAR(C45),12,1)),68,74)

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

 

[Guest]

Thanks. That worked.

=IF(AND(C45>DATE(YEAR(C45),4,15),C45<DATE(YEAR(C45),12,1)),68,74)

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)