I want to set a formula (or macro) in a cell so that it will pick-up the last
date entered in Column B. Column B is set for dates for an expense report.
I have row/cells R/S 2&3 Merged for an underlined "Expenses From:" date field
that uses
the date from cell b8. (the first open date field for a new expense report).
I want Excel to automatically pick up the last date in a completed expense
report and report it in the Thru: field for a from/thru effect. Am using
cell U2 for this last date of line item entries. How can I get excel to pick
up the last date no matter what row the user fills out?

If you want to help even more, I then want to take the dates from R2 and U2
and in cell V1 make it into a #, i.e. if R2=01/02/07 and U2=01/30/07 then V1
will = 010207-013007.

Am I asking for the moon and the stars or just the moon here?

Thanks for all your help, I truly appreciate it. Apologies for any headache
caused!