Please i need to know what formular to use to calculate prorated salary for a given year base on hire and fire date.
Thanks.
Cell a3= hire date
cell b3= termination date
cell c3= annual salary
cells d3 - o3= months in a year (jan-dec)
Please i need to know what formular to use to calculate prorated salary for a given year base on hire and fire date.
Thanks.
Cell a3= hire date
cell b3= termination date
cell c3= annual salary
cells d3 - o3= months in a year (jan-dec)
Based on your information, try this formula in cell D4 and drag through O4:
Then you can paste this formula into any unpopulated cell:Please Login or Register to view this content.
Hope this helps.Please Login or Register to view this content.
Spread the love, add to the Rep
"None of us are as smart as all of us."
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks