| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
HOW DO I CALCULATE WEEKLY PAYMENTS THAT VARY BY LENGTH OFTHE M
i know i am asking for a lot...sorry
"Mike H" wrote: Mary, What I think you may mean is that some months have (say) 4 Mondays and some have 5 so if you make your payments on a Monday then some months you make 4 payments and others 5. This will calculate the Mondays in the month of a date in a1 =SUMPRODUCT(--(WEEKDAY(ROW(INDIRECT(A1&":"&EOMONTH(A1,0))))=2)) For other days of the week change the last 2 where 1=Sunday and 6 = Saturday. -- Mike When competing hypotheses are otherwise equal, adopt the hypothesis that introduces the fewest assumptions while still sufficiently answering the question. "Mary" wrote: I make weekly payments for my son's school, every week is the same amount but the total per month may be different since some months have more weeks than others...How do i put that in a formula?? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how to calculate interest on payments | Excel Discussion (Misc queries) | |||
| Bi-weekly mortage payments | New Users to Excel | |||
| How do I get a formula to calculate the third Thursday of the mont | Excel Discussion (Misc queries) | |||
| Bi weekly payments per month | Excel Worksheet Functions | |||
| how do i calculate my mortgage payments | Excel Worksheet Functions | |||
Hybrid Mode
