Split years into weeks and get a date

Hi,

A situation: A meeting have been convening since 17-Sep-1992 on weekly basis.

How can we get next meeting exact date with formula AND VBA as there may have been difference due to leap years.

Note: Meeting was never missed on every 7th day. So how can get a list of all the previous meetings as well

I am expecting a single line code or formula and not loops