As fast as you can, select your merged cells and press Ctrl-1. Go to the
Alignment tab and unmerge your cells, then select Merge Across Selection in
the Horizontal Alignment box.

Then write on the chalk board 1000 times "I will NEVER merge cells again"

To get the last numeric (including date) entry in a column, use the formula

=INDEX(B:B,MATCH(9.99999999999999E+307,B:B))


"wardawg" wrote:

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!