-1

I want the Duedate to change as per Payment Terms in Google sheet

Due date       Terms
7/20/2020      **Due on receipt**
6/29/2019      Net30
4/5/2020       Net 15
5/7/2020       Net 60
6/8/2020       Net 40

I managed to change the due date Net 30,15,60,40 using =B2+right(C2,2) in the cell and getting accurate results but i am unable to get result for Due on receipt as it does not follow the logic for the Net terms.

James Z
  • 12,209
  • 10
  • 24
  • 44
Karan Singh
  • 1

1 Answers1

0
=B2+IFERROR(REGEXEXTRACT(C2,"\d+$"),0)
idfurw
  • 5,727
  • 2
  • 5
  • 18