Salary Calculation based on hire date plus 30% Fringe

Hello!

Thank you for taking time in reviewing.

Id like to have a formula on P6 that will calculate the FY compensation based on the hire date which on M6 plus a 30% Fringe calculation.

Please help if possible !

Thanks!

you may need to provide some expected results -- and, for ex.,

- will your start dates always going to be 1st of month - if not, how will you pro-rate (based on a given day, or days worked in month etc)
- implication is you may have hourly employees - how will the calculation differ for those individuals

some basic examples

- using a pro-rated 365 days
=YEARFRAC(M6-1,DATE(2021,12,31),3)*$O6*12*(1+$P$3)

-using DATEDIF (if always 1st of month)
=DATEDIF(M6-1,DATE(2021,12,31),"m")*$O6*(1+$P$3)

etc