Prorating Salary based on hire date and Term date

[KimberlyWelty]

Trying to edit the monthly salary based on hire date and/or termination date of employees. The formula I have is working, unless the person is not terminated. I know it must be something simple, but having trouble making it work. If anyone is able to assist or simplify my formula, that would be great.

Here is the formula I am using:
=IF(OR($B2>EOMONTH(E$1,0),$C2<E$1),"",$D2*(MIN(EOMONTH(E$1,0),$C2)-MAX(E$1,$B2)+1)/IF(MOD(YEAR($E$1),4)=0,366,365))

 

[ExceLoki]

try this:

IF(OR($B2>EOMONTH(E$1,0),IF($C2="",EOMONTH($P$1,0),$C2)<E$1),"",$D2*(MIN(EOMONTH(E$1,0),IF($C2="",EOMONTH($P$1,0),$C2))-MAX(E$1,$B2)+1)/IF(MOD(YEAR($E$1),4)=0,366,365))

 

[KimberlyWelty]

try this:

IF(OR($B2>EOMONTH(E$1,0),IF($C2="",EOMONTH($P$1,0),$C2)<E$1),"",$D2*(MIN(EOMONTH(E$1,0),IF($C2="",EOMONTH($P$1,0),$C2))-MAX(E$1,$B2)+1)/IF(MOD(YEAR($E$1),4)=0,366,365))

Thank you!!!

 

[ExceLoki]

happy to help.
if this worked for you, please consider marking it as a solution for others to find