finding last and creating average amount income to date

Hi,
In col B are dates in col F are the amounts paid. in A1 I want to create
the average months income. Generating the avearge using the part of the
month not just an entire month.

If I am at 10 days into a month or 20 days etc. the average will reflect
just that part of the month. So if I am at three months and 17 days have
the average month reflect that.

Thank you,
Jerry

=AVERAGE(IF((B2:B32<>"")*(B2:B32<=TODAY()),F2:F32))

which is an array formula, it should be committed with Ctrl-Shift-Enter, not
just Enter.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Jerry Kinder" <[email protected]> wrote in message
news:[email protected]...
> Hi,
> In col B are dates in col F are the amounts paid. in A1 I want to create
> the average months income. Generating the avearge using the part of the
> month not just an entire month.
>
> If I am at 10 days into a month or 20 days etc. the average will reflect
> just that part of the month. So if I am at three months and 17 days have
> the average month reflect that.
>
> Thank you,
> Jerry
>
>