On Thu, 25 Feb 2010 14:58:08 -0800, JJ in LA
wrote:

I need to create a list or table that returns all pay dates for the 15th and
last day of the month for an entire year. The date must adjust forward when
the normal pay date falls on a weekend or holiday, e.g. the 15th is Sunday so
pay day is the 12th. My attempts have resulted in excessive formulas and no
concrete answer.

It would be more convenient if you just expanded your request in the same
thread as you started, instead of starting a new one.

In any event, you can modify the technique I suggested before, to meet your
newly stated requirements, by entering:

=WORKDAY(DATE(Year_Ref,ROWS($1:1)/2+1,MOD(ROWS($1:1),2)*15+1),-1,Holidays)

in some cell and filling down to the end of the year (total of 48 rows).

Year_Ref is the year you are interested in, or a cell containing that year.

Holidays represents a range where you have listed the holidays for the year
specified by Year_Ref.

--ron