Forum Discussion
Solved
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. Thanks in advance
See the attached the workbook.
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.
Thank you very much for your usual support,
Could you provide me with a formula to sum the amount per year
See the attached the workbook.
- Many Thanks Mr. Hans