View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
CLR CLR is offline
external usenet poster
 
Posts: 1,998
Default how to advance dates by one year then up to 10 yrs in Excel

Depends on "exactly" what you want as a result..........

This, copied down column A would give equal time periods of "about 3 months"

=A1+365.25/4

Vaya con Dios
Chuck, CABGx3



"chaplyn" wrote:

Doing an amortization table beginning with 10/2007 want to quickly advance
the dates quarterly for the next 10 years.
Thanks