| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Auto date entry for status change
Hi, Latest brainteaser, I have a Excel 2000 pro workbook, in one of the spreadsheets I have column (E) that uses a dropdown list (Data/Validation/List). I want the next column (F) to automatically show the date that the entry to column E was last changed or if there has been no change show a generic start date.... Is this possible? -- Alec H ------------------------------------------------------------------------ Alec H's Profile: http://www.excelforum.com/member.php...o&userid=31042 View this thread: http://www.excelforum.com/showthread...hreadid=508924 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula to change number into date | Excel Discussion (Misc queries) | |||
| How change Excel default date format to something useful | Excel Discussion (Misc queries) | |||
| Help: Can I change the date formula from mm/dd/yyyy to "mmm-yy" et | Excel Discussion (Misc queries) | |||
| cell color change based on due date | New Users to Excel | |||
| How would I change a date cell to decrease it by business days? | Excel Discussion (Misc queries) | |||
Threaded Mode
