Need more info:

another spreadsheet

Does that mean another worksheet in the same file or a worksheet in another
file?

The source spreadsheet has columns of numbers with a date header.

Are these numbers all in the same row or are the numbers in many rows? Where
are these numbers? For example - A2:F10 or A2:Z2.

I need...the date of the last column containing data.

You need the date header that corresponds to the rightmost cell within the
range that contains a numeric value? What type of data is in the range? Is
it all numeric? Any text? Any formula blanks?

--
Biff
Microsoft Excel MVP


"Karen" wrote in message
...
I have a spreadsheet with a cell linked to another spreadsheet "Last Date
Entered". The source spreadsheet has columns of numbers with a date
header. I
need to formulate a cell that shows the date of the last column containing
data. Thanks! (Without this resource I couldn't do my job)--
Excelsolutions4U