View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
David Biddulph[_2_] David Biddulph[_2_] is offline
external usenet poster
 
Posts: 8,651
Default consecutive bi-monthly dates

If you've got 15 Sep 07 in A1, then in A2 put =DATE(YEAR(A1),MONTH(A1)+1,0)
which will give the last day of the month.
In A3 put =DATE(YEAR(A1),MONTH(A1)+1,DAY(A1)) to give 15th of the next
month.
Select A2 and A3, and fill down.
--
David Biddulph

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