ExcelBanter - Report data from cell if dates match

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Report data from cell if dates match (https://www.excelbanter.com/excel-discussion-misc-queries/219771-report-data-cell-if-dates-match.html)

WildWill

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!

Roger Govier[_3_]

Report data from cell if dates match

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

--
Regards
Roger Govier

"WildWill" wrote in message
...
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!

All times are GMT +1. The time now is 04:36 AM.