Generate date on Semi-Monthly Basis
Try:
a1 = 4/15/2008
a2 =date(year(a1),month(a1)+1,if(day(a1)=15,0,15))
Regards,
Fred
"debinnyc" wrote in message
...
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!
|