LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 168
Default Show value from one cell in another cell if today falls between adate range

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
displaying text in a cell if a another cell falls in a range THIRDCOAST Excel Worksheet Functions 2 February 1st 08 06:24 PM
IF CELL VALUE FALLS WITHIN A RANGE OF VALUES Melvin Tang Excel Worksheet Functions 8 September 4th 07 04:59 AM
If date in cell falls between date range... Keep It Simple Stupid Excel Worksheet Functions 4 August 28th 07 10:02 PM
Show blank when today() is within a certain date range Sarah (OGI) Excel Worksheet Functions 3 May 18th 07 01:31 PM
update cell only if now() falls in a given date range treyn1292 Excel Worksheet Functions 0 February 16th 06 08:54 PM


All times are GMT +1. The time now is 10:07 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"