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 -- |
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? |
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? |
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? |
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! |
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! |
All times are GMT +1. The time now is 09:45 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com