Hi Carina
Formula can't push information to other cell, it can only pull information.
the result is were you put the formula.
A macro could do it.
HTH
John
"Carina" wrote in message
...
I have a cell with today's date, and I have a seperate row of dates. Can i
create a formulat that takes today's date, finds the date from the list of
dates, then populates the data next to the date in the rows?

Any help would be appreciated.