SOLVED

# Formula assist

Brass Contributor

# Formula assist

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.

4 Replies

# Re: Formula assist

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.

# Re: Formula assist

Thank you very much for your usual support,

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

best response confirmed by Hussein_Mohamed (Brass Contributor)
Solution

# Re: Formula assist

See the attached the workbook.

# Re: Formula assist

Many Thanks Mr. Hans
1 best response

Accepted Solutions
best response confirmed by Hussein_Mohamed (Brass Contributor)
Solution

# Re: Formula assist

See the attached the workbook.