This doesn't work as I need. [
"=IF(A2=EOMONTH(A2,0),A1+14,IF(MONTH(A2)=MONTH(A2+ 14),A2+14,EOMONTH(A2,0)))"]

For my loan:
D10 = Loan_Start = 3/20/09
A19 = Payment #1 = 3/27/09
A19 €“ A29 = Payments 1 €“ 11, irregular payments trying to set a schedule
A30 = first regular, scheduled biweekly payment = Monday, June 8 = Payment 12
Everything following should be every other Monday + every EOMONTH

Your formula gives 3 dates per month where 2 Mondays exist in the month,
but they are every 14th and every 28th + every EOMONTH. I need them to be
every Monday + every EOMONTH. Your formula never gives 3 Mondays + EOMONTH,
but two months should have these 4 dates.

I can ignore payments 1 -11 since they are not on a schedule, but I need to
begin my schedule by specifying the date for payment 12, Monday, June 8, and
then follow a biweekly schedule + EOMONTH from then on.

Is this possible to do?

--
staplers


"Fred Smith" wrote:

As you said "anything is welcome", here's a formula to do what you want.
Assumes starting date is in a2:
=IF(A2=EOMONTH(A2,0),A1+14,IF(MONTH(A2)=MONTH(A2+1 4),A2+14,EOMONTH(A2,0)))

Regards,
Fred

"staplers" wrote in message
...
I can fill cells of a column with all 26 recurring biweekly Mondays (for
instance) in the year. I can fill cells of a column with all 12 EOMONTHs
in
the year. But I cannot do both at once. How can I create a column that
lists selected biweekly days/dates including EOMONTH for all 12 months?
10
months would have two biweekly days/dates plus one EOMONTH (3 dates) and
two
months would have three biweekly days/dates plus one EOMONTH (4 dates).
This
is for an Open Ended loan I am trying to track with an amortization plan
where I make 26 payments per year, every other Monday, and a Loan
Protection
Plan charge is added to my loan the last day of every month (No, I don't
like
being forced to pay interest on the extra loan amount, but I cannot
pre-pay
it monthly.) I want a €œglobal€� formula using defined ranges, not one that
sequences from the previous/last cell to test and fill the next/succeeding
cell. However, anything is welcome.
--
staplers