The ffollowing formula will do the trick:

=IF(DAY(G1)=15,DATE(YEAR(G1),MONTH(G1)+1,1)-1,DATE(YEAR(G1),MONTH(G1)+1,15))
--
Kevin Backmann


"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!