| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
AutoName Sheets by current date
Hi everyone... I was wondering what code I need to use to force excel to rename newly created worksheets as the current date. ie.(today is 25-May-06, therefore when I create a new sheet, I want it to name the sheet 25-May-06.) I know it's a bit silly because I can just name them each day.... however I have one of these for each day of the year and 7 different workbooks all with the same "naming" scheme. Any help would be greatly appreciated. -- Cromag_762003 ------------------------------------------------------------------------ Cromag_762003's Profile: http://www.excelforum.com/member.php...o&userid=34810 View this thread: http://www.excelforum.com/showthread...hreadid=545664 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Most Current Date | Excel Worksheet Functions | |||
| Formula to subtract a date from current date | Excel Worksheet Functions | |||
| enter a current date in a cell? | Excel Discussion (Misc queries) | |||
| calculating excel spreadsheet files for pensions and life insurance (including age calculation sheets) | Excel Worksheet Functions | |||
| Calculating days between current date and a date in future NETWORKDAYS() function | Excel Worksheet Functions | |||
Threaded Mode
