Thanks in advance for the help.
Sample sheet is attached in Desktop Excel, but I need to adapt to Google Sheets
I have an array formula in Google sheets that pulls a monthly salary based on start date and current month, but I also need to add a 3% raise at each work anniversary??? Any suggestions??
So for employee one - I need a 3% increase starting 6/1/24 - 5/1/24, then an additional 3% starting 6/1/25-5/1/25.
Possible?, not overly complicated?