Create a counter using SUM and today's Date in formula?

[brothaprice]

Hello:

I am trying to get the total sum of a field called "Numrequestedaddresses" where the "contractCity" field equals "CC" and the "Feetype" field equals "Non-Subdivision". I would like a counter to calculate the total sum and I would like the counter set 14 days in the future. The total sum would change dynamically if there are any updates during the 14 days until it expires. I want the "FinalDate" field to be the parameter for the 14-day intervals. Is this possible with the today() method or by setting expiration dates?

 

[mart37]

Indeed, with the function today() you can use the current date for calculations.
With the function SUMIFS you can calcualte the sum with a lot off criteria.

 

[brothaprice]

Indeed, with the function today() you can use the current date for calculations.
With the function SUMIFS you can calcualte the sum with a lot off criteria.

I think SUMIFS will be good. What date function will help me get the proper date ranges to be used with the SUMIFS? The sum counting would start the 1st of 15th of every month and expire two weeks into the future.

 

[mart37]

Something like this: =DATE(YEAR(TODAY()),MONTH(TODAY()),IF(DAY(TODAY())<15,1,15))

 

[brothaprice]

Something like this: =DATE(YEAR(TODAY()),MONTH(TODAY()),IF(DAY(TODAY())<15,1,15))

My apologies. I discovered that I cannot use the excel formula because I am using data connected to access. I would have to configure the formula/query in the power query editor before I load the table into excel. I am going to start fresh by asking a power query related question.