[sorry for replying to you Peter,
I lost the original post]

I think you want the IF/AND/OR/BUT/NOT syntax?
IF(OR(NOW()="2/1/2008",NOW()<="2/29/2008",H4,IF(OR( etc.

"RickLM" .(donotspam) wrote in message
...
I need to select value from different cell depending on if NOW() is within
certain date rate ranges using:
IF(NOW() =2/1/2008 OR <=2/29/2008,H4,IF(NOW() =3/1/2008 OR
<=3/31/2008,I4,xxxRepeat IF for n of date rangesxxx)
OR
BETWEEN AND
or some other/better way
Date range may or may not be a complete moth and could be like 2/15/2008
and
3/28/2008
Thanks
--
RickLM