| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Automatically filling date of today (without it changing tomorrow)
I have tw columns
Column A = Date Column B = Questions In column A I have a formula =IF(B2<"";TODAY();""). This means, that if I type a letter in column B and press enter the date of today is automatically filled in in Column A. With the usage of Today() the date will change tomorrow, to tomorrow's date. I don't want it to change. So what should happen is: I type in a letter (or sentence or whatever) in column B today (which is 27 june 2006) is automatically entered. Tomorrow I want to check the question and the date in front of it remains 27 june 2006. Does this make sense? Please help me......Thanx -- ** Fool on the hill ** |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Automatically Changing Cell Reference's when Pasting in Excel | Excel Discussion (Misc queries) | |||
| Changing date format in a footer | Excel Discussion (Misc queries) | |||
| how do i make a date change automatically if i change one before . | Excel Discussion (Misc queries) | |||
| How do I stop today() from updating date on saved spreadsheets? | Excel Discussion (Misc queries) | |||
| prevent 4/5 in a cell automatically transfer to a date format | Excel Discussion (Misc queries) | |||
Threaded Mode
