Prevent cell update if valued

Originally Posted by WDGOR

...the formula below looks for the range of dates from 1/1/2014 to 12/31/2014 and returns a value. The Pipeline sheet is updated monthly.

I may not be understanding your question, but I don't see why you are looking for a range of dates for the whole year if you are trying to capture a figure for January.