+ Reply to Thread
Results 1 to 2 of 2

Salary Distribution and 3 percent increment every year on hire date

  1. #1
    Registered User
    Join Date
    05-24-2021
    Location
    georgia
    MS-Off Ver
    16
    Posts
    10

    Question Salary Distribution and 3 percent increment every year on hire date

    Hello,

    I have data set consisting information like Salary, Hire Date, Termination Date, Status of employee.

    We want to distribute that salary in 12 months and also want to factor 3% increment every year from their joining date and want to factor in condition that if any employee joins in current year, we dont want to give 3% salary raise.

    I'm attaching Excel working file for your reference

    Current Solution I'm using is

    1. First calculation pro rates the salary in 12 month based on hire and termination date

    2. Second calculation fulfills 3% increment YOY based on hire date.

    Problem

    How can combine both formula to make it fully automized calculation by pro rating salary based on Hire and termination date and 3% increments YOY in there base salary until they are active employee
    Attached Files Attached Files
    Last edited by ruchpatel1993; 05-27-2021 at 12:28 PM. Reason: to learn excel

  2. #2
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2019
    Posts
    17,428

    Re: Salary Distribution and 3 percent increment every year on hire date

    Hello ruchpatel1993 and Welcome to Excel Forum.
    I am not totally sure that I understand what you want, however try pasting the following in cell G20 then copying over and down:
    Formula: copy to clipboard
    Please Login or Register  to view this content.

    Let us know if you have any questions.
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Vacation Accrual - hire date and calendar year
    By dgohmann in forum Excel General
    Replies: 2
    Last Post: 05-06-2022, 10:51 AM
  2. Salary Calculation based on hire date plus 30% Fringe
    By dmejia174 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-04-2021, 10:27 AM
  3. [SOLVED] Need to prorate annual salary based on hire date?
    By taylorsm in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-02-2018, 03:25 PM
  4. Replies: 1
    Last Post: 11-22-2017, 05:27 AM
  5. [SOLVED] Need formula for prorating monthly salary based on hire/fire date and annual salary.
    By Excel_Help_Pls in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 08-06-2015, 12:56 AM
  6. Salary monthly allocation based on Hire date
    By thomas.mapua in forum Excel General
    Replies: 1
    Last Post: 08-21-2011, 08:45 PM
  7. [SOLVED] add a hire date to the end of year (12/31/05) and get Total years
    By Sohoma Knome in forum Excel General
    Replies: 2
    Last Post: 12-28-2005, 11:25 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1