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