Good evening!

I want to show the value of one cell (cell A1, for example) in a different cell (cell B1, for example) if today falls between a certain date range. If today does not fall between the date range, display zero. For example:

The value in A1 is $5.00, and today is 1/30/2013. If today falls between date range 1/1/2013 - 1/31/2013, display $5.00 in B1. If today were 3/20/2013, B1 would display $0.00.

I have the dates for the year in a different column (C1:C365), in case this is needed in the formula.

I've tried numerous functions, and none seem to work. I'd appreciate any help!