Report data from cell if dates match
 

I have:
Cell A1: 10 Jan 09 (Today's Date)
Cell A2: 12 Jan 09 (Target Date)
Cell B1: Value "X" (dynamic values that change continuously)
Cell B2:Empty

I need a statement that will consider the two date values, and when they are
the same, the value of B1 will also be displayed in B2.

Example:

Cell A1: 12 Jan 09
Cell A2: 12 Jan 09
Cell B1: Value "X"
Cell B2: Value "X"

Thanks!

Report data from cell if dates match
 

In B2:

=IF(A1=A2,B1,"")

Regards,
Stefi

€žWildWill€� ezt Ã*rta:

I have:
Cell A1: 10 Jan 09 (Today's Date)
Cell A2: 12 Jan 09 (Target Date)
Cell B1: Value "X" (dynamic values that change continuously)
Cell B2:Empty

I need a statement that will consider the two date values, and when they are
the same, the value of B1 will also be displayed in B2.

Example:

Cell A1: 12 Jan 09
Cell A2: 12 Jan 09
Cell B1: Value "X"
Cell B2: Value "X"

Thanks!

Report data from cell if dates match
 

In B2:
=IF(A1=A2,B1,"")

Regards,
Stefi

€žWildWill€� ezt Ã*rta:

I have:
Cell A1: 10 Jan 09 (Today's Date)
Cell A2: 12 Jan 09 (Target Date)
Cell B1: Value "X" (dynamic values that change continuously)
Cell B2:Empty

I need a statement that will consider the two date values, and when they are
the same, the value of B1 will also be displayed in B2.

Example:

Cell A1: 12 Jan 09
Cell A2: 12 Jan 09
Cell B1: Value "X"
Cell B2: Value "X"

Thanks!

Report data from cell if dates match
 

First format the column A to date values. Then,
Select the cell B2 and paste following formula
=IF(A2=A1,B1,"")
Now select the cell B2 and drag it down to apply the formula to other cells
too.

Hop this works for you€¦

Have a nice time


Chris
------
Convert your Excel spreadsheet into an online calculator.
http://www.spreadsheetconverter.com

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200902/1