Hey guys! I posted this in the General Forum, but I figured this would
be a better place for this question. I was wondering if I could get
some help here. I would like to update a cell based on a date range.
For example, I would like to update the value of a cell to the value of
another cell if the current date is between July 1st and July 10th.
However, if the date is outside the date range, I want the value for
that cell to not be updated, and be the previous value. Can anyone give
me an example as to how I would do this? Thanks!!!


--
deversole
------------------------------------------------------------------------
deversole's Profile: http://www.excelforum.com/member.php...o&userid=22672
View this thread: http://www.excelforum.com/showthread...hreadid=384545