Need to figure out a way to pull data based on a dynamic date range

[tatarrific]

Hi all - total newbie, need help please.

I was able to figure out how to create formulas to calculate prorated salary per month based on start/end dates, but am stumped on the next step. I want to be able to filter the totals for date ranges, so that I can say, show me salary totals from 1/1-6/30 only, or from 9/30-12/31 only. I thought there'd be an easy way to do it through a pivot, but maybe there's a better way to do it with a formula? Any help most appreciated.

[Pepe Le Mokko]

Administrative Note:

Welcome to the forum.

We would very much like to help you with your query, however it has been brought to our attention that the same query has been posted on one or more other forums and you have not provided the required cross-post link(s) here.

Please see Forum Rule #3 about cross-posting and adjust accordingly. Read this to understand why we (and other sites like us) consider this to be important.

As you are new I will add it for you this once https://www.mrexcel.com/board/thread...range.1163122/

[tatarrific]

facepalm Apologies! I will do better next time. Do you need me to do anything further with this post?

[Pepe Le Mokko]

Nope, just let it be, answers will come when members are available.
Just try to read the provided link, it's really important