Set a revision date based on document type and issue date

[Simon Hook]

I have different document types and their review dates will vary according to type, 1 year or 2 years.

example, if a form or worksheet was issued today then the review date will be in 2 years. If a procedure then the review date will be 1 year from issue. Eventually there will be 6 or 7 document types.

See attachment for sheet layout .

Any help with the formula would be greatly appreciated.



Thanks

 

[Muhammad_Usman]

Receip.xlsm
	A	B	C	D
1	RML/FM/GL/1		08-Sep-23	07-Sep-24
2	RML/FM/GL/2		08-Sep-23	07-Sep-25
3	RML/FM/GL/3		08-Sep-23	07-Sep-26
4	RML/FM/GL/4		08-Sep-23	07-Sep-27
5	RML/FM/GL/5		08-Sep-23	06-Sep-28
25

Cell Formulas
Range	Formula
D1:D5	D1	=C1+(365*RIGHT(A1,1))

Check out this one

 

[Fluff]

Hi & welcome to MrExcel.
How about

=EDATE(J2,SWITCH(C2,"Procedure",1,"Form",2,0)*12)

 

[Simon Hook]

Receip.xlsm
	A	B	C	D
1	RML/FM/GL/1		08-Sep-23	07-Sep-24
2	RML/FM/GL/2		08-Sep-23	07-Sep-25
3	RML/FM/GL/3		08-Sep-23	07-Sep-26
4	RML/FM/GL/4		08-Sep-23	07-Sep-27
5	RML/FM/GL/5		08-Sep-23	06-Sep-28
25

Cell Formulas
Range	Formula
D1:D5	D1	=C1+(365*RIGHT(A1,1))

Check out this one

thanks, will give it a try

 

[Simon Hook]

Hi & welcome to MrExcel.
How about

=EDATE(J2,SWITCH(C2,"Procedure",1,"Form",2,0)*12)

thank you

I presume I can add additional document types by adding in this section:

(C2,"Procedure",1,"Form",2,0)

Can I ask what the 0 at at the end is for?

Simon

 

[Fluff]

The 0 is just a default value to prevent an error if C2 does not equal any of the values.