Log In
Register
Home
May 10, 2022
Offline
Hello All,
I have the below two columns: I would like to put a formula in the Plan Date to copy the start date but only the first time the start date is entered.
1. When I open the workbook, both columns below are blank
Start Date, Plan Date
2. When I type a date in Start Date for the first time, I would like that date to be copied into Plan Date
Start Date Plan Date
01/28/23, 01/28/23
3. I then save and close out my workbook then I come back in and update the Start Date. I wouldn't want Plan Date to be updated
Start Date Plan Date
01/30/23, 01/28/23
I have tried a few things but nothing is working. Any feedback is greatly appreciated.
Thanks
Michele
VIP
Trusted Members
December 7, 2016
Offline
Hello,
Type in the start date, go to next cell and press the F4 key to repeat the previous entry.
If F4 does not work, press CTRL + Y instead.
Br,
Anders
May 10, 2022
Offline
Thank you for your response but I was hoping to avoid having to do anything manual after typing the start date which is why I was looking for a formula. Everytime I insert a new row in the table the formula would automatically copy down so I don't have to worry about populating it.
VIP
Trusted Members
December 7, 2016
Offline
Hello,
One should perhaps test the tips to see if they work as intended. Turns out the F4 / CTRL + Y keyboard shortcuts is for commands, for example setting red font colour in one cell, then you can use those shortcuts to repeat, does not work for entries.
Another tip then, this one tested and verfied it works as intended.
Highlight both cells, type in the date, press CTRL + ENTER and you will now have the date in both cells.
Any way, it is no point in using a formula for this kind of scenario.
Br,
Anders
1 Guest(s)
