Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
how do i convert a number of days to years, months & days? | Excel Discussion (Misc queries) | |||
Add years NOT days | Excel Worksheet Functions | |||
Convert years to years and days | Excel Discussion (Misc queries) | |||
convert Days to Years, Months, Days | Excel Discussion (Misc queries) | |||
Convert # of days to years/days | Excel Discussion (Misc queries) |