Is a date in summer or winter?

T

Thea

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.
 
P

Peo Sjoblom

Maybe something like

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

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)
 
T

Thea

Thanks. That worked.

Bob Phillips said:
=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)
Click to expand...
 
Top