On Wednesday, January 30, 2013 4:07:27 PM UTC-8, perpetual159 wrote:
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!









--

perpetual159

Hi perpetual159,

In B1 =IF(AND(TODAY()=C1,TODAY()<=C2),A1,0)

With the parameter dates in C1 and C2.
Format B1 as currency.

Regards,
Howard