Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Inserting a static date into a function
So here's what I am trying to do:
I've created a pull-down list with a checkmark and I would like to create a function for another cell that will insert the date that the checkmark was added. The tricky part is getting that date to stay static instead of changing to the computer's date (as with the TODAY() and NOW() functions). I know that I have to us an IF function (like IF(A1=checkmark, "STATIC DATE", "") ... and the static date is the thing that is killing me. In addition, my company's computers do not take kindly to macros, so if there is anyway that I am able to do this through a function, that would be ideal. Thanks! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Inserting a static date into a function
This can't be done with a formula. You would need to use a Macro or have the
user manually input the date. Note, a shortcut to input the current date is CTRL+; HTH, Elkar "FIF780" wrote: So here's what I am trying to do: I've created a pull-down list with a checkmark and I would like to create a function for another cell that will insert the date that the checkmark was added. The tricky part is getting that date to stay static instead of changing to the computer's date (as with the TODAY() and NOW() functions). I know that I have to us an IF function (like IF(A1=checkmark, "STATIC DATE", "") ... and the static date is the thing that is killing me. In addition, my company's computers do not take kindly to macros, so if there is anyway that I am able to do this through a function, that would be ideal. Thanks! |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Inserting a static date into a function
What about putting the "CTRL+;" into the function ... is there a way to
"functionate" that phrase? "Elkar" wrote: This can't be done with a formula. You would need to use a Macro or have the user manually input the date. Note, a shortcut to input the current date is CTRL+; HTH, Elkar "FIF780" wrote: So here's what I am trying to do: I've created a pull-down list with a checkmark and I would like to create a function for another cell that will insert the date that the checkmark was added. The tricky part is getting that date to stay static instead of changing to the computer's date (as with the TODAY() and NOW() functions). I know that I have to us an IF function (like IF(A1=checkmark, "STATIC DATE", "") ... and the static date is the thing that is killing me. In addition, my company's computers do not take kindly to macros, so if there is anyway that I am able to do this through a function, that would be ideal. Thanks! |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Inserting a static date into a function
You can do it without VBA but involves circular references and changing
iterations See JE McGimpsey's site. http://www.mcgimpsey.com/excel/timestamp.html "Using circular references and worksheet functions" Gord Dibben MS Excel MVP On Thu, 1 Feb 2007 12:14:01 -0800, FIF780 wrote: So here's what I am trying to do: I've created a pull-down list with a checkmark and I would like to create a function for another cell that will insert the date that the checkmark was added. The tricky part is getting that date to stay static instead of changing to the computer's date (as with the TODAY() and NOW() functions). I know that I have to us an IF function (like IF(A1=checkmark, "STATIC DATE", "") ... and the static date is the thing that is killing me. In addition, my company's computers do not take kindly to macros, so if there is anyway that I am able to do this through a function, that would be ideal. Thanks! |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Inserting a static date into a function
This method does work, but be careful using it. The Iterations setting has a
habit of turning itself back off if you have a different workbook open prior to opening this one. This should not affect any timestamps already in place, but could prevent future timestamps from being applied accurately. HTH, Elkar "Gord Dibben" wrote: You can do it without VBA but involves circular references and changing iterations See JE McGimpsey's site. http://www.mcgimpsey.com/excel/timestamp.html "Using circular references and worksheet functions" Gord Dibben MS Excel MVP On Thu, 1 Feb 2007 12:14:01 -0800, FIF780 wrote: So here's what I am trying to do: I've created a pull-down list with a checkmark and I would like to create a function for another cell that will insert the date that the checkmark was added. The tricky part is getting that date to stay static instead of changing to the computer's date (as with the TODAY() and NOW() functions). I know that I have to us an IF function (like IF(A1=checkmark, "STATIC DATE", "") ... and the static date is the thing that is killing me. In addition, my company's computers do not take kindly to macros, so if there is anyway that I am able to do this through a function, that would be ideal. Thanks! |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Inserting a static date into a function
Elkar
Good point. I personally would not use this method, preferring a change event to stamp the cell. OP wanted a non-VBA approach but I should have pointed out the caveat as you did. Gord On Thu, 1 Feb 2007 13:31:01 -0800, Elkar wrote: This method does work, but be careful using it. The Iterations setting has a habit of turning itself back off if you have a different workbook open prior to opening this one. This should not affect any timestamps already in place, but could prevent future timestamps from being applied accurately. HTH, Elkar "Gord Dibben" wrote: You can do it without VBA but involves circular references and changing iterations See JE McGimpsey's site. http://www.mcgimpsey.com/excel/timestamp.html "Using circular references and worksheet functions" Gord Dibben MS Excel MVP On Thu, 1 Feb 2007 12:14:01 -0800, FIF780 wrote: So here's what I am trying to do: I've created a pull-down list with a checkmark and I would like to create a function for another cell that will insert the date that the checkmark was added. The tricky part is getting that date to stay static instead of changing to the computer's date (as with the TODAY() and NOW() functions). I know that I have to us an IF function (like IF(A1=checkmark, "STATIC DATE", "") ... and the static date is the thing that is killing me. In addition, my company's computers do not take kindly to macros, so if there is anyway that I am able to do this through a function, that would be ideal. Thanks! |
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) | |||
LINKEDRANGE function - a complement to the PULL function (for getting values from a closed workbook) | Excel Worksheet Functions | |||
Need some comments on my Utility_Move class module. | Excel Worksheet Functions | |||
Date & Time | New Users to Excel | |||
Using date function in an if statement | Excel Worksheet Functions |