Counting Payments (Not Years or Days)

N

NFL

This spreadsheet will only be used to count payments - not days or years.
For example, the difference between bi-weekly and bi-monthly is that there
could be 3 payments required on any given month whereas the bi-monthly will
only require 2 payments. The way its' designed is that the end user will
enter the dates in Col A and the number of weeks, months, etc.. will appear
on the other columns. Here's the layout .... Hope this makes and also what's
been used. The Monthy and Semi-Monthly doesn't always work right...

col B formula: =INT((A3-A2)/7+1)
col C formula: =INT((A3-A2)/14+1)
col D formula: =E1*2
col E Formula: =SUM(F2, 1)
Col F Formula: =DATEDIF(A2,TODAY(),"m")

Col A Col B Col C Col D Col E
Col F
Weekly Bi-Weekly Semi-Monthly Monthly
Start Date B2 ... etc..
End Date B3 ... etc

Thank you!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top