Forum Discussion
Solved
Calculate a Fee if between a Date and on ProjID
Hello Experts, I need to apply a rate to the excel table based on the following criteria: 1. if the [date] is between the rate table [Date From] and [Date To] 2. also on [ProjID] The tricky...
=INDEX(Table2[Rate],MATCH(1,([@ProjID]=Table2[ProjID])*([@Date]>=Table2[Date From])*([@Date]<=Table2[Date To]),0))*[@Amt]*(30/360)Maybe with this formula. Enter the formula with ctrl+shift+enter if you don't work with Office365 or 2021.
=INDEX(Table2[Rate],MATCH(1,([@ProjID]=Table2[ProjID])*([@Date]>=Table2[Date From])*([@Date]<=Table2[Date To]),0))*[@Amt]*(30/360)Maybe with this formula. Enter the formula with ctrl+shift+enter if you don't work with Office365 or 2021.
Hi, I am not sure what is happening but it says thre is a best response give to Grahmfs13. I do not see that response though?