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!
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!