Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how do I program a cell to automatically fill in today;s date?
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how do I program a cell to automatically fill in today;s date?
allan, if you want the date to change put this in a cell, =TODAY()
if you don't want the date to change use a line of code like this maybe in a workbook open event Sheets("Sheet1").Range("A1") = Date -- Paul B Always backup your data before trying something new Please post any response to the newsgroups so others can benefit from it Feedback on answers is always appreciated! Using Excel 2002 & 2003 "allanlevy7342" wrote in message ... |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to add todays date (static) to the current active cell using m | Excel Discussion (Misc queries) | |||
insert date | Excel Worksheet Functions | |||
run a macro in a locked cell | Excel Discussion (Misc queries) | |||
Addition to Turn cell red if today is greater or equal to date in cell | New Users to Excel | |||
How do I program a cell to automaticinput the current date as dat. | Excel Worksheet Functions |