Hi,

Put your start day in A1 and the in A2 and drag down

=IF(DAY(A1)=15,EOMONTH(A1,0),DATE(YEAR(A1),MONTH(A 1)+1,15))

Mike

"debinnyc" wrote:

I am using Excel 2003 and trying to determine a formula to generate the next
date on a semi monthly basis. For example, I have a cell for next pay date,
which when filled in I want the other cells to automatically generate the
next pay date accurately. If I enter 4/15/2008 as my next paydate, then I
want the other cells to readout 4/30/2008, 5/15/2008, 5/31/2008, etc. Any
help would be greatly appreciated. Thanks!