One way:

Enter the first date in cell A1. Either the 15th or the last date of that
month. Like this:

A1 = either 1/15/2007 or 1/31/2007

Enter this formula in A2 and copy down as needed:

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

--
Biff
Microsoft Excel MVP


"dmr" wrote in message
...
Is there a way to consecutively add bi-monthly dates to a spreadsheet?
Kind
of different because the 15th will always be 15. It's the last day of the
month that changes each month. This would be for people who are paid
bi-monthly so the dates don't have to be input each time.