Interpolating values between two dates

[ScottF123]

Hi,

I hope you are all well!

I currently have a dataset containing monthly financial data and quarterly financial data. I wish to linearly interpolate the quarterly data to monthly data so I can conduct some analysis between the two sets of financial data. I was using the excel 'fill' function to fill the blank cells as a linear trend but the full dataset spans 15 years; I found this process quite slow since I could only fill 2/3 months at a time. I'm looking for a more efficient way to complete this task.

I have attached a screenshot of some of the dataset which should help explain my situation. As you can see I have filled 'Div. Growth' using the excel 'fill' function but given the frequency of the data in the dataset I can only interpolate 2-3 cells at a time.

[IMG alt="thumbnail image 1 of blog post titled











Interpolating values between two dates












"]https://techcommunity.microsoft.com...8565B98340/image-size/large?v=v2&px=999[/IMG]

All help is appreciated!

Thanks!

 

[ScottF123]

See

 

[Fluff]

Welcome to the MrExcel Message Board!

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at: Interpolating values between two dates
and here https://www.excelforum.com/excel-fo...3-interpolating-values-between-two-dates.html
If you have posted the question at more places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.

 

[ScottF123]

Hi @Fluff ,

Correct, I also posted there. I done so in an attempt to reach a broader audience since my initial post (Interpolating values between two dates) didn't receive any solutions and I am working towards a deadline for a university project. I haven't posted on any additional forums.

Any help on my issue would be greatly appreciated!

Thanks

 

[ScottF123]

This query has been resolved on another forum, please see:

Re: Interpolating values between two dates

Thank you ! Looks good. I have the LET() function so I will try to apply it to my dataset now. Thanks for your help!

techcommunity.microsoft.com

&

Interpolating values between two dates

Hi, I hope you are all well! I currently have a dataset containing monthly financial data and quarterly financial data. I wish to linearly interpolate the quarterly data to monthly data so I can conduct some analysis between the two sets of financial data. I was using the excel 'fill'...

www.excelforum.com