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/219764-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"
Cell B2: Empty

I need a statement that will check the dates in A1 & A2, and when they are
the same, will place whatever the value of B1 is at that time, into B2, i.e.
to achieve the following:

Cell A1: 12 Jan 09 (today's date)
Cell A2: 12 Jan 09 (target date)
Cell B1: Value "X"
Cell B2: Value "X"

Please help!

Ron@Buy

Report data from cell if dates match

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

"WildWill" wrote:

I have:

Cell A1: 10 Jan 09 (today's date)
Cell A2: 12 Jan 09 (target date)
Cell B1: Value "X"
Cell B2: Empty

I need a statement that will check the dates in A1 & A2, and when they are
the same, will place whatever the value of B1 is at that time, into B2, i.e.
to achieve the following:

Cell A1: 12 Jan 09 (today's date)
Cell A2: 12 Jan 09 (target date)
Cell B1: Value "X"
Cell B2: Value "X"

Please help!

muddan madhu

Report data from cell if dates match

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

WildWill wrote:

I have:

Cell A1: 10 Jan 09 (today's date)
Cell A2: 12 Jan 09 (target date)
Cell B1: Value "X"
Cell B2: Empty

I need a statement that will check the dates in A1 & A2, and when they are
the same, will place whatever the value of B1 is at that time, into B2, i.e.
to achieve the following:

Cell A1: 12 Jan 09 (today's date)
Cell A2: 12 Jan 09 (target date)
Cell B1: Value "X"
Cell B2: Value "X"

Please help!

All times are GMT +1. The time now is 08:30 PM.