M
Mike
Hi all,
I am trying to take a spreadsheet that has columns labeled by the week
ending date. One section of rows are recurring payables, some of which are
bi-weekly, weekly, monthly (by varying date - 15th, 12th, 20th ... etc.),
and quarterly .
I am asking if someone can direct me as to how to get a bi-weekly (or
weekly, or monthly ... etc.) payment to carry itself across the sheet ...
into the appropriate weeks. What we presently have is col.A lists vendors;
Col.B lists frequency or date (15th, 20th, Q, M, B, W....) and Col.C is the
expected recurring payment amount. Basically the remaining columns are the
weeks of the year.
Thank you for your help and time
Mike
I am trying to take a spreadsheet that has columns labeled by the week
ending date. One section of rows are recurring payables, some of which are
bi-weekly, weekly, monthly (by varying date - 15th, 12th, 20th ... etc.),
and quarterly .
I am asking if someone can direct me as to how to get a bi-weekly (or
weekly, or monthly ... etc.) payment to carry itself across the sheet ...
into the appropriate weeks. What we presently have is col.A lists vendors;
Col.B lists frequency or date (15th, 20th, Q, M, B, W....) and Col.C is the
expected recurring payment amount. Basically the remaining columns are the
weeks of the year.
Thank you for your help and time
Mike