Hi,
I need to create a Payroll Forecast for 2019 using the following information: start salary, raise (new salary), raise effective date, stop date (all dates are end of month only).
For every person I need formula that will do the following:
- check if there is stop date for that person,if yes $0 from that month, if not take start salary and divide with 10
- check if there is a potential raise for that person, if yes take new salary and divide by 10
I do not know how to create a formula that can work in the following scenario: start salary until March, in March raise to $X, stop date in September so $0 until the end of the year.
Could you please help.
Thanks in advance.
Best,
Boris
Bookmarks