Follow up Q to how to add a certain number of days to a date in excel

Hello,

Thank you for your article with the handy tip.

What way would one make use of to fill the contents of a single row (or column, depending how one has structured one's table) to follow a certain pattern.

ie. On an annual budget with a biweekly breakdown of anticipated expenses, I think it would be nifty to be able to say write a line of code to the effect of:

While the number of columns is less than or equal to 12, add 14 days to the first date entered into the row, store that date in a variable, print the computed date onto the cell beside it.

The output ought to be a neat row of dates that span a single year.

Would this be doable using a function or would it be better to use a VB script?

Thank you for looking into this for me.

Regards,

Izanagi