2 questions again
i got it right to give a sheet the same name as the contents of a cell, but
that cell entry is a date formula and it seems that that's not
acceptable...is there a way of entering the date in, say cell E1, then have
the sheet name displayed as that date?

what would the macro look like to duplicate an existing sheet, giving it
today's date as a name - the date would be entered in a cell.