Hello All,
I am having trouble adding another condition to this long formula (see attached excel file). The formula already prorates monthly salary based on both the hire date and the termination date. However, I now need to incorporate a salary increase % based off a salary increase date. (Columns U and V) in the attached spreadsheet. Any help on how to tweak this formula to add this condition would be much appreciated.
Thanks!
Bookmarks