Formula assist

[Hussein_Mohamed]

Dears,

Could you please assist with a formula to apply for a list of contracts that include start date & end date with increase % per year such as the attached sample.

Thanks in advance

[#2]

@Hussein_Mohamed 

Option 1: in all versions of Excel, enter the formula

=IF(OR(AC$1<$K2,AC$1>$L2),"",$P2*(1+$O2)^DATEDIF($K2,AC$1,"y"))

in AC2, then fill to the right.

Option 2: for Excel in Microsoft 365 or Office 2021 only, enter the formula

=IF((AC$1:FG$1<$K2)+(AC$1:FG$1>$L2),"",$P2*(1+$O2)^DATEDIF($K2,AC$1:FG$1,"y"))

in AC2. It will automatically spill to the right.

[#3]

@HansVogelaar 

Thank you very much for your usual support, 

Could you provide me with a formula to sum the amount per year

[#4 · Accepted solution]

@Hussein_Mohamed 

See the attached the workbook.

[#5]

Many Thanks Mr. Hans