Home |
Search |
Today's Posts |
#3
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
displaying text in a cell if a another cell falls in a range | Excel Worksheet Functions | |||
IF CELL VALUE FALLS WITHIN A RANGE OF VALUES | Excel Worksheet Functions | |||
If date in cell falls between date range... | Excel Worksheet Functions | |||
Show blank when today() is within a certain date range | Excel Worksheet Functions | |||
update cell only if now() falls in a given date range | Excel Worksheet Functions |