Quote:
Originally Posted by perpetual159
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!
|
Hi,
Have a look at the attached. Set out slightly different to your post but the idea is the same.
You could hardcode dates into the formula but if the dates in the future should happen to need altering it's easier to amend if they are in cells rather than hardcoded.
Hope that helps.
S.