Adding consecutive dates in Excel 2010 using VBA

Hello,

I am trying to find some code which will allow the date in my spreadsheet to update automatically every time it's opened and a new entry is added. For example, if I bought some eggs for £1 on the 10th September, I would want Excel to enter 10th September automatically in one column when I update the other columns with "eggs" and £1. I am currently using Excel 2010 and I am pretty sure there's some code out there which can do it. I just haven't found it yet. So any suggestions would be most welcome!

Thanks

Hi,

Here is a website that has code that I think you are looking for.

http://www.ozgrid.com/VBA/auto-add-date.htm

Hope this is helpful.

Cheers