Forum Discussion

kesha_11's avatar
kesha_11
Copper Contributor
Apr 26, 2023

Value based on the date

Hello, I would like to ask for some advice in regard to an issue I am having with a formula. I'm trying to create a spreadsheet with the contract start date, end date, total value, charges to be paid...
  • HansVogelaar's avatar
    Apr 26, 2023

    kesha_11 

     

    Change Table1 to the name of the table.

     

    =IF(--LEFT(Table1[[#Headers],[2019-2020]],4)=YEAR(Table1[@[Contract Start Date]:[Contract Start Date]]),Table1[@[Fees to be paid in the first year]:[Fees to be paid in the first year]],IF(AND(--LEFT(Table1[[#Headers],[2019-2020]],4)>YEAR(Table1[@[Contract Start Date]:[Contract Start Date]]),--LEFT(Table1[[#Headers],[2019-2020]],4)<=YEAR(Table1[@[Contract End Date]:[Contract End Date]])),Table1[@[Fees to be paid for the rest of the contract]:[Fees to be paid for the rest of the contract]],""))

Resources