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

[perpetual159]

Good evening!

I want to show the value of one cell (cell A1, for example) in
different cell (cell B1, for example) if today falls between a certai
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 betwee
date range 1/1/2013 - 1/31/2013, display $5.00 in B1. If today wer
3/20/2013, B1 would display $0.00.

I have the dates for the year in a different column (C1:C365), in cas
this is needed in the formula.

I've tried numerous functions, and none seem to work. I'd appreciate an
help

 

[lhkittle]

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 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

 

[Claus Busch]

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

 

[Claus Busch]

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

 

[Spencer101]

Good evening!

I want to show the value of one cell (cell A1, for example) in
different cell (cell B1, for example) if today falls between a certai
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 betwee
date range 1/1/2013 - 1/31/2013, display $5.00 in B1. If today wer
3/20/2013, B1 would display $0.00.

I have the dates for the year in a different column (C1:C365), in cas
this is needed in the formula.

I've tried numerous functions, and none seem to work. I'd appreciate an
help!

Hi,

Have a look at the attached. Set out slightly different to your pos
but the idea is the same.

You could hardcode dates into the formula but if the dates in the futur
should happen to need altering it's easier to amend if they are in cell
rather than hardcoded.

Hope that helps.

S

+-------------------------------------------------------------------
|Filename: perpetual159 example.zip
|Download: http://www.excelbanter.com/attachment.php?attachmentid=748
+-------------------------------------------------------------------

 

[perpetual159]

Hi,

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

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


Regards
Claus Busch

Thank you, Claus. That worked perfectly

+-------------------------------------------------------------------
+-------------------------------------------------------------------