Please post response as email use is bogus to prevent spam. Thank you.

I am struggling with the following:

I want to have a cell that looks up the date value and put in the
correct value depending upon the date.

I have set the datevalue for certain months and compare them with the
=Now() in another cell that these will read off of.

Month one values are beginning 38504 end 38533 (other values based on
this) result in cell x6
Month two values are beginning 38534 and 38562 (other values based on
this) result in cell x7
My =Now() is in cell v1
If cell v1 is between 38504 and 38533 I want this cell value to be x6,
but if v1 if between 38534 and 38562, I want cell value to be x7.

Here is what I have come up with so far (and added month value in this
one) but it’s not working:
=IF(OR($V1>=38504,$V1<=38533),$X6,OR($V1>=38534,$V1<=38562,X7,(OR($V1>=38565,$V1<=38590,X8))))

I’d appreciate any help.

Thanks in advance.

baz