View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
debinnyc debinnyc is offline
external usenet poster
 
Posts: 10
Default Generate date on Semi-Monthly Basis

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!