Prev: VBA to sidestep popups...
Next: Help for sharing a worksheet from a excel sheet
From: Mary on 1 Apr 2010 14:26
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??
From: Mike H on 1 Apr 2010 14:44
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??
 | 
Pages: 1
Prev: VBA to sidestep popups...
Next: Help for sharing a worksheet from a excel sheet