Forecasting salary with date ranges

[xxkaykayxx]

Hi, would really appreciated any help here. I am trying to forecast salaries. So far the formula can account for any pay rises and bonuses in the right period. I cant figure out how to get the forecast to stop continuing after their end date, within the formula I already have. I feel like this should be a lot simpler than it is. Any help would be greatly appreciated, Ive attached the screenshot.

My current formula: =($J55/12)+((IF((MONTH($K55)<=MONTH(S$2)),(($N55/12)),0)))+((IF(AND($O55>=S$2,$O55<=S$1),$Q55,0)))

 

[OaklandJim]

I can't promise that I can do this but I'll try. The worst case is that you have a custom function (called a User Defined Function or UDF) bult using VBA that does what is needed, if worksheet formulas do not work.

Pictures are not very helpful. If the data is not confidential hopefully you could post a link to your workbook. Use the link icon above the message area. Put the file on Dropbox, Box, 1Drive, Google Drive etc.

Or, consider sharing some of the data using Mr Excel's excellent XL2BB addin that enables you to post a portion of a worksheet. Show an example of the desired result.