Macro to insert value based on date plus value in other cells

[Jibroni]

Hello,

I need a macro or formula (or both??) to insert an end date into column E. Here is my spreadsheet:

Class ID	Course Title	Calendar Event Name	Scheduled Class Start Date	Scheduled Class End Date
06052022_GST_301	301 Administration Fundamentals		6/5/2022​	6/7/2022​
08102022_CET_401	401 Custom MPE Rules Using Regular Expression		8/10/2022​
08122022_CET_402	402 Threat Detection with AI Engine		8/12/2022​
08112022_PT_302	302 AI Engine Fundamentals		8/11/2022​
08122022_PT_305	305 Analyst Fundamentals		8/12/2022​

The "Scheduled Class End Date" value is based on the last three numbers of the value in the first column, "Class ID." It's based on the following key:
301 = 3 days
401 = 2 days
402 = 1 day
302 = 1 day
305 = 1 day
...and so on for future values.

For example, the Scheduled Class End Date in the first row is 6/7/2022, because the Class ID has "301", which is equal to 3 days, and the class begins on 6/5/2022, as you can see in the "Scheduled Class Start Date" column.

I appreciate your help as always!
Jibs

 

[Peter_SSs]

Make a lookup table for the added days then a formula like this?

22 04 16.xlsm
	A			D	E	F	G	H	I	J
1	Class ID			Scheduled Class Start Date	Scheduled Class End Date				Code	Days
2	06052022_GST_301			05-Jun-22	07-Jun-22				301	3
3	08102022_CET_401			10-Aug-22	11-Aug-22				401	2
4	08122022_CET_402			12-Aug-22	12-Aug-22				402	1
5	08112022_PT_302			11-Aug-22	11-Aug-22				302	1
6	08122022_PT_305			12-Aug-22	12-Aug-22				305	1
End Date

Cell Formulas
Range	Formula
E2:E6	E2	=D2+VLOOKUP(RIGHT(A2,3)+0,I$2:J$10,2,0)-1

 

[Jibroni]

Thank you, @Peter_SSs ! This is will do the trick!

 

[Peter_SSs]

You're welcome. Thanks for the follow-up.