Report data from cell if dates match

W

WildWill

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!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Report data from cell if dates match 2
Capturing Trend Data over time 1
Find the position of a date 6
simple week entry 2
Name of the Day 2
Conditional Formatting with if statement 1
How to determine the highest occurrence? 4
Referencing a cell even if its contents are moved moved/replaced 6

Top