Glad to help.



Actually I set a range to the active document, then looked for something that looks like the start of a date, then moved the end of the found range to the end of its paragraph (not including the mark), then verified it was a date.

As for the function. I didn't do all of that on a lark today. I've tinkered with code to return a calculated age based on a birthday but never took it past years, months and days. Today I groomed that code to drill down to seconds.

It may appear classy but I sit in a pile of scalp and bloody hair. I am not the whiz kid with dates and math functions. Not quite 30 but almost 20.

__________________
Greg Maxey
Please visit my web site at http://www.gregmaxey.com/