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