On Mon, 18 Apr 2005 12:28:01 -0700, "David G" <David
wrote:

That is exactly right, but I have no idea how the formula is working, because
of $F$3 anchors.

=WorKDAY(edate($F$3,ROW()-3)-1,1)

Let's start from the inside:

ROW() returns the row in which the formula is located.

So in F4, ROW() will return a 4; in F5 ROW() will return a 5 and so forth.

Since the base cell is in F3, we subtract 3 from this to determine how many
months to add to the value in F3.

EDATE(start_date,months) adds this previously determined number of months to
the date in F3. It takes care of adjusting for the end of the month so that
one month after Jan 31 will still be the end of February.

The WORKDAY function is then used to eliminate weekends. By subtracting 1 from
the date we compute with EDATE, and then adding 1 WORKDAY to it, we will
effectively skip over the weekends.

Hope this is clear.


--ron