Dears,
I have created a excel template to apply the Proposed Billed Date of Customers (please refer the attached excel sheet). I added a keyword in the column "I", and the formulatext in the column "J". I planned to use "VLOOKUP" function to apply the formulatext to the corresponding keywords in the Customer Billing file but I require a function which works exact opposite of "FORMULATEXT" to generate the billing date. Can anyone please help me on this.
Many Thanks,
Vignesh M
I have created a excel template to apply the Proposed Billed Date of Customers (please refer the attached excel sheet). I added a keyword in the column "I", and the formulatext in the column "J". I planned to use "VLOOKUP" function to apply the formulatext to the corresponding keywords in the Customer Billing file but I require a function which works exact opposite of "FORMULATEXT" to generate the billing date. Can anyone please help me on this.
Many Thanks,
Vignesh M
Attachments

11.3 KB Views: 17