The NPER function should compute this. See help for more info.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"Paul Ilacqua" wrote in message
...
Could someone post the formulas necessary to calculate how long
a lump sum will last if I withdraw X amount with it earning x %
interest. I've used a canned financial calc and it does not
seem correct.
Thank You

Paul