Here is one way, but it requires one more column.

Firstly in B1, enter this formula

=IF(Sheet2!$C$1:$C$100<TODAY(),"",ROW())

and copy down to say B100 (assuming 100 tasks for a day is the limit ;-)).

Then select all of the cells C1:C100, and copy this formula into the formula
bar and commit it with Ctrl-Shift-Enter

=IF(ROW(Sheet2!$C$1:$C$100)-ROW(Sheet2!C1)+1COUNT(B1:B100),"",
INDEX(Sheet2!D:D,SMALL(B1:B100,ROW(INDIRECT("1:"&R OWS(Sheet2!$C$1:$C$100))))
))

You should see numbers with gaps in column B, and the tasks with no gaps in
column C.

It can all be don e in one formula, but I can't find where I did that at the
moment.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"VJ7777" wrote in message
...

My objective is to create a list of actions to be taken today. On one
worksheet I have dates in
Column A which are in order 1/1/05, 1/2/05, 1/3/05, etc. In column B
there
is a different activity
for each day. Obviously it is easy to use VLOOKUP Today() to capture
today's activity and print it in a column 1 on a report.

In Column C the dates are in random order and many cells are blank.
Whenever there is a date in
Column C there is an accompanying activity in Column D. How can I capture
today's activity
and print it in column 2 of the report? What happens if today's date
appears twice in Column C?

Thank you in advance for any ideas you can offer.