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!

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

Show value from one cell in another cell if today falls between a date range
 

Hi,

Am Thu, 31 Jan 2013 00:07:27 +0000 schrieb perpetual159:

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.

in B1 try:
=IF(MONTH(TODAY())=1,A1,"")


Regards
Claus Busch
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2

Show value from one cell in another cell if today falls between a date range
 

Hi,

Am Thu, 31 Jan 2013 08:55:41 +0100 schrieb Claus Busch:

in B1 try:
=IF(MONTH(TODAY())=1,A1,"")

correction:
in B1 try:
=IF(MONTH(TODAY())=MONTH(C1),A1,"")


Regards
Claus Busch
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2

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.

Thank you, Claus. That worked perfectly!