Hi!

The file must already exist ( having been saved and given a file name):

=DATEVALUE(MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,255))

Format the cell as DATE

This will return the current year. If you need a specific year:

=DATEVALUE(MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,255)&"-year_number")

Replace year_number as needed: 05, 1999, 2000, 02 etc.

Biff

wrote in message
oups.com...
I work on bank reconciliations and the tabs say "7-19", "7-18" etc.
Figured out how to auto copy the tab data but how can I add to it so it
reads "7-19-06"?

THANKS!!!