Home |
Search |
Today's Posts |
#1
|
|||
|
|||
AutoPopulate DATE in Excel
When I enter info into one cell, I want the date to populate in another. And stay. Like when one thing gets signed off I want the Date of the signature happening.
Is there a way to do this WITHOUT using a Macro? As I need the file saved on a shared drive, and for some reason I cannot get the file to save with a Macro.... =[ Please help |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
AutoPopulate DATE in Excel
When I enter info into one cell, I want the date to populate in another.
And stay. Like when one thing gets signed off I want the Date of the signature happening. Is there a way to do this WITHOUT using a Macro? This seems to work with Excel 2003. First, permit circular references by checking the box at: Tools Options Calculation Iteration Start with all cells empty. In B1 put =IF(A1="","",IF(B1="",NOW(),B1)) and copy down if needed. Format column B as desired; as a date, for example.. Next enter a value into column A next to one of the formulas. The date (and time, if included in the format) should appear in column B next to the value. What's in column B does not change if the file is saved and re-opened in the future. It also does not change if somebody overwrites a value in column A with something different. If a column A value is deleted, the corresponding column B cell should become empty too. Caution: permitting circular references can be risky and is discouraged by many. If somebody later puts a circular reference in the file by mistake, Excel won't catch the error. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Want current date to autopopulate a textbox | Excel Programming | |||
Excel Drop Down/ Autopopulate | Excel Worksheet Functions | |||
Using Excel to autopopulate color.. | Excel Discussion (Misc queries) | |||
How to autopopulate column w/May using a col w/ 05/15/07(Excel)? | Excel Programming | |||
autopopulate date | Excel Discussion (Misc queries) |