Thread: Variable Range for NPV
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Spiky Spiky is offline
external usenet poster
  
Posts: 622
Default Variable Range for NPV
Try the EDATE function. If A1 is the beginning date and B1 is the
number of years.
=EDATE(A1,B1*12)
Reply With QuoteReply With Quote