trying to calculate severance pay formula

[excelrooki3]

So I am trying to calculate severance pay in a column. I have multiple columns but the ones I need to create a formula with are :yrs with company and total salary column.

Mind you to get severance pay is - # of yrs with the company x 2 weeks of regular pay. Does anyone know of a formula I can use to calculate this?

 

[HockeyDiablo]

sounds like an easy fix, can you provide an example so I know what im working with?

Provide like 5 made up employees, show me a before and after.

 

[Dave Patton]

Excel 2010
	A	B	C	D	E	F
1	Name	Start_E	End_	Years	Regular Salary	Severance
2	ABC	1-Jan-06	31-Dec-15	10	4,000.00	40,000.00
3	BBB	1-Jan-15	31-Mar-16	1	1,500.00	1,500.00
4	BBB	1-Jan-15	31-Mar-16	1	1,500.00	1,500.00
5	BBB	1-Jan-15	31-Mar-16	1.25	1,500.00	1,875.00
5a

Cell Formulas
Range	Formula
F2	=D2*E2
D2	=DATEDIF(B2-1,C2,"Y")
D3	=DATEDIF(B3-1,C3,"Y")
D4	=INT(YEARFRAC(B4-1,C4,1))
D5	=ROUND(YEARFRAC(B5-1,C5,1),2)

How is Number of Years defined? Is it full years of 365+ days?