View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
JJ in LA[_2_] JJ in LA[_2_] is offline
external usenet poster
 
Posts: 4
Default Need formula to calculate bi-monthly pay dates

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.