Payroll Breakup

mbolsen
✭
Hello,
I have pay dates on the 15th and the last day each month. A person may be contracted for say 21 days and that pay needs to be parsed out depending on what days that employee worked in that time period. I am having a hard time coming up with an equation for each pay-period cell. Pay, 1/15, 1/31, 2/15....
Tags:
Comments
-
Oh I figured it out. Using the PRORATE formula. neat
Help Article Resources
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!