Show value from one cell in another cell if today falls between a date range
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!
|