Forum Discussion
bryan1009
Mar 03, 2024Copper Contributor
Auto date insertion
I need to auto insert date in A1 when a2 is populated
bryan1009
Mar 09, 2024Copper Contributor
Thank you. #1 works for me, not being VBA competent, but the date changes to the current date wheneverIopenthespreadsheet. Which isnt what i wanted, sadly. I need the date to be static
tThanks
Bryan Evans
HansVogelaar
Mar 09, 2024MVP
That's weird. If you followed the instructions exactly as posted, the date will be static.
I have attached a sample workbook. When I saved it, A1 contained the 7th of March, 2024.
Does it change to the current date when you open the workbook?
- bryan1009Mar 09, 2024Copper ContributorMy apologies. I hadn't enabled Iterative calculation. Took me a bit of |Googling to find it. I thought it was on the toolbar ribbon. Doh. No, it opened on the 7th as you forecast.
Again, Thank you