Enter this in A1 & fill down to A24:
=IF(MOD(ROW(),2)=1,DATE(2007,(ROW()+1)/2,15),DATE(2007,ROW()/2+1,0))

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