Create table with 1 year of dates 1 week apart
Posted on 2014-03-20
With a given base date say of 1/1/2014, I would like to create a record set of 52 records incrementing the date by 1 week in each record so it is the same day-of-week in each date (taking Leap year into account). Each record also needs to be consecutively numbered beginning with 1 on the base date and 52 on the last.
Macro's are nice but I think this needs to be VBA.
Help is appreciated.