I want to have a static date in one cell as the "origination date", it will be automated when I generate the form. The second date will be the "approval date" generate by the =today function when the form is signed and approved. There may be days or weeks between "origination date" and "approval date". How do I go about making sure the "origination date" stays static when the form is approved days or weeks later.
If you type in a date manually it will stay static?
If you want it automated when generating a form, I assume that you have some VBA? If this is the case you can do an =TODAY() and then copy/paste special/values in VBA. Just record the steps and use that code
You should hit F5, because chances are I've edited this post at least 5 times.
Example of Array Formulas
Click the * below on any post that helped you.Originally Posted by Jacc
If you want a static date in a cell, you have three options. 1) You can type a valid date in. 2) You can press Ctrl-; to enter today's date. Or 3) you use VBA to store a date in the cell.
Whenever/wherever you use =TODAY(), it will be udated to reflect the current date.
Regards, TMS
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
The VBA to store a date in cell A17, for example, is
Please Login or Register to view this content.
Regards, TMS
@Speshul: thanks for the rep and feedback
And Ctrl-: puts the current time in the cell
Regards, TMS
I really wanted to avoid manual input, but it looks to be my best bet. Thanks for the help.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks