Is a date in summer or winter?
 

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.

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.

Is a date in summer or winter?
 

=IF(AND(C45DATE(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)

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

Is a date in summer or winter?
 

Thanks. That worked.

"Bob Phillips" wrote:

=IF(AND(C45DATE(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)

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