CAGR based on daily data

Hello,

I have encountered with a problem that I couldn't resolve.

My goal is to calculate CAGR based on Daily data for the defined period.
The formula for the CAGR is = (Ending equity/Starting Equity)^(1/number of years) -1.

Because I calculate CAGR using daily data I assumed 250 days (work days) in a year and converted the days to years by changing formula to
(Ending equity/Starting Equity)^(1/(number of days/250) -1.

Here is the code

Please Login or Register  to view this content.

(see attached file)

The main problem is that Days360 calculate calendar days between dates, but I need to find the real dates between my Start and End period.

Can somebody help me to find CAGR for the defined period.

Thanks in advance.

Thank you for your help. Your example is really much better.
But I'd like to ask another question. Using Match function we have found that the difference between days is 23 (36-13). But is it possible to include the first day to calculation so the actual result would be 24?

Thank you

ooops, sorry. My inattention.
Thanks again