Forum Discussion
Auto date insertion
I need to auto insert date in A1 when a2 is populated
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
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?
- My 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