| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
date stamp
I've got =IF(Inventory_list!C2="y", Inventory_list!A2, 'formulas etc'!$D$9)
on a master sold sheet. d9 refers to a blank cell. I've also got on the master sold sheet, =IF(A2<0, 'formulas etc'!$D$14) for a date column. d14 refers to today's date. The d14 today's date is fine as the initial input to a cell, but I want to datestamp the dates on the master sold sheet so they do not update. Actually, I want to do this to the whole column so as dates get entered periodically, they do not change from the inital value. What do I need to do and thanks. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Separating date from a Date & Time stamp | Excel Discussion (Misc queries) | |||
| Create a button that will date stamp todays date in a cell | Excel Discussion (Misc queries) | |||
| Date stamp spreadsheet in excel to remind me of completion date | Excel Worksheet Functions | |||
| Date Stamp | Excel Discussion (Misc queries) | |||
| date stamp | Excel Discussion (Misc queries) | |||
Threaded Mode
