View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
WildWill WildWill is offline
external usenet poster
 
Posts: 64
Default 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!