View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
[email protected] bpkaufman@gmail.com is offline
external usenet poster
 
Posts: 19
Default CAGR with six month lag

I know how to calculate cagr though can someone please let me know if
this seems right for cagr with a six month lag?

((January 1, 1992 Value/July 1, 1991)^2)-1)*100

For some reason this has not been working for me...

Thanks,
bk