Thanks a lot binuacs - as your solution helped me a lot and solve my problem of putting a date on a file name that has four sheets. I wanted hypens in the date, so I used '%Y-%m-%d'. Unfortunately I won't share my solution because it contains sensitive company info. I do have a minor problem - in that the first sheet of the four does not appear unless I copy it in. And on the 'Data Preview' of the formula tool it shows nothing, unlike the other three. But this is not a big problem, and I will try to google to resolve.