Execute formula if date range is between 2 cells

[Drwats0n]

Hey guys. what do i add in this formula if i want to execute this formula below if date range is between C2 and D2

C2 = 1 March 22
D2 = 31 March 22

=SUM(IFS(Summary!C424:C454<Summary!C$468,(Summary!C424:C454*0.6%)/360,Summary!C424:C454>Summary!C$468,(Summary!C$468*0.6%/360+(Summary!C424:C454-Summary!C468)*0.8%/360)))

 

[earthworm]

=IF(and(C2>=44621,D2<=44651,SUM(IFS(Summary!C424:C454<Summary!C$468,(Summary!C424:C454*0.6%)/360,Summary!C424:C454>Summary!C$468,(Summary!C$468*0.6%/360+(Summary!C424:C454-Summary!C468)*0.8%/360))),"")

 

[Joe4]

I don't think the previous formula will work for you, if you are trying to check the dates that are located in column A, like in your previous question here: Replace criteria range in countifs to be based on 2 cells date

The question really is where are the date(s) that you are trying to compare to the dates in cell C2 and D2?

I would find it more helpful if you showed us what your data looks like, and just tell us what you are trying to return?

 

[Drwats0n]

Hi Joe, thanks for the reply again. similar to my previous question, i want to avoid manually changing the dates column in the formula whenever i have new dates added to the row.
I want the existing formula to calculate the interest cost between start and end March by only updating C2 and D2. Thank you for looking.

 

[Drwats0n]

can anyone help me with this ?

 

[earthworm]

can anyone help me with this ?

Kindly share the data in xl2bb format and highlight the answer that you require.