Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Date formula
Hi All
I would like to put today's date into a cell by entering data into another cell, the following is what I am using now: = IF(B3="","",TODAY()) If I open the worksheet tomorrow, then the date will change, how do I get the date to not change? Thanks George Gee -- |
#2
|
|||
|
|||
Take a look at
http://www.mcgimpsey.com/excel/accumulator.html In article , "George Gee" wrote: Hi All I would like to put today's date into a cell by entering data into another cell, the following is what I am using now: = IF(B3="","",TODAY()) If I open the worksheet tomorrow, then the date will change, how do I get the date to not change? |
#3
|
|||
|
|||
Thanks for your time.
However, I feel that this is going to be beyond me! The formula that I gave as an example, is copied down to row 100, so I am not sure what you are trying to tell me! George Gee *JE McGimpsey* has posted this message: Take a look at http://www.mcgimpsey.com/excel/accumulator.html In article , "George Gee" wrote: Hi All I would like to put today's date into a cell by entering data into another cell, the following is what I am using now: = IF(B3="","",TODAY()) If I open the worksheet tomorrow, then the date will change, how do I get the date to not change? |
#4
|
|||
|
|||
Can I try another way?
The following macro puts the date in the active cell: ActiveCell.FormulaR1C1 = "1/17/2005" Range("A2").Select End Sub Question: How do I edit this so that the cell to the right of the active cell is selected, when the macro is run? Thanks for your patience! George Gee *JE McGimpsey* has posted this message: Take a look at http://www.mcgimpsey.com/excel/accumulator.html In article , "George Gee" wrote: Hi All I would like to put today's date into a cell by entering data into another cell, the following is what I am using now: = IF(B3="","",TODAY()) If I open the worksheet tomorrow, then the date will change, how do I get the date to not change? |
#5
|
|||
|
|||
one way:
ActiveCell.Value = Date ActiveCell.Offset(0, 1).Select In article , "George Gee" wrote: The following macro puts the date in the active cell: ActiveCell.FormulaR1C1 = "1/17/2005" Range("A2").Select End Sub Question: How do I edit this so that the cell to the right of the active cell is selected, when the macro is run? Thanks for your patience! |
#6
|
|||
|
|||
JE
Many thanks. George Gee *JE McGimpsey* has posted this message: one way: ActiveCell.Value = Date ActiveCell.Offset(0, 1).Select In article , "George Gee" wrote: The following macro puts the date in the active cell: ActiveCell.FormulaR1C1 = "1/17/2005" Range("A2").Select End Sub Question: How do I edit this so that the cell to the right of the active cell is selected, when the macro is run? Thanks for your patience! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
date format within a cell containing a formula | Excel Discussion (Misc queries) | |||
Formula with text and reference to a date cell | Excel Discussion (Misc queries) | |||
Date Formula | Excel Discussion (Misc queries) | |||
Date formula | Excel Discussion (Misc queries) | |||
How do I add a date formula to a cell but hide the contents with . | Excel Discussion (Misc queries) |