| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Automatic Date Insertion?
Hello, I was curious if there was a macro or some function I could enter in a paticular cell of a reusable workbook that would automatically enter the Date with Day in the cell when the workbook is opened? If so, how would I implement this? Thank You Very Much! -- tristatefab ------------------------------------------------------------------------ tristatefab's Profile: http://www.excelforum.com/member.php...o&userid=32647 View this thread: http://www.excelforum.com/showthread...hreadid=524549 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Automatic Date Insertion?
In the cell of your choice enter =NOW() and format it as a date however you choose. -- intruder9 ------------------------------------------------------------------------ intruder9's Profile: http://www.excelforum.com/member.php...o&userid=30107 View this thread: http://www.excelforum.com/showthread...hreadid=524549 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Automatic Date Insertion?
Do you know about =TODAY() ?
-- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "tristatefab" wrote in message ... Hello, I was curious if there was a macro or some function I could enter in a paticular cell of a reusable workbook that would automatically enter the Date with Day in the cell when the workbook is opened? If so, how would I implement this? Thank You Very Much! -- tristatefab ------------------------------------------------------------------------ tristatefab's Profile: http://www.excelforum.com/member.php...o&userid=32647 View this thread: http://www.excelforum.com/showthread...hreadid=524549 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Need to Improve Code Copying/Pasting Between Workbooks | Excel Discussion (Misc queries) | |||
| How do I calculate if a date is in a certain time frame? | Excel Worksheet Functions | |||
| Automatic Date Entry | Excel Worksheet Functions | |||
| How do I set an automatic date stamp into a cell in Excel? | Excel Worksheet Functions | |||
| Automatic date change when spreadsheet changes | Excel Worksheet Functions | |||
Linear Mode
