Tabs can not be formated with any of these characters (\/:*?<|) it .
So 6/1/07 will not work
You can use VBA to change the tab name to = 6107 0r 060107 or Mar 06,07 and
so on


"Kelvin Beaton" wrote:

Oh, and I like the date in the TAB to be formatted, like 6/4/07.

Thanks

Kelvin


"Kelvin Beaton" <kelvin at mccsa dot com wrote in message
...
I have a spreadsheet that has a calculated date field in "=H34+3"

I would love for the TAB to equal that value.

I think I've tried to figure this out a long time back, but I think I got
stuck becasue it is a calculated fileld.

Anyone know if this can be done, and how?

Thanks

Kelvin