Forum Discussion
Formula for Expiration Tracking
Hello All, I am on an HP PC, Windows 10, using Excel 2016. My organization has a spreadsheet that is used to track an incentive program. Nurses in our organization can record the hours they s...
Hello Riny_van_Eekelen,
I do like the way this looks.
However, we have records for over 1,000 nurses currently participating in the program. I'm not sure how this structure would translate for that many individual records.
This does give me some new ideas though.
Thank you!!!!
I do like the way this looks.
However, we have records for over 1,000 nurses currently participating in the program. I'm not sure how this structure would translate for that many individual records.
This does give me some new ideas though.
Thank you!!!!
In your linked spreadsheet I added a row I called Expired and it calculates how much of the previously earned PIP expired that month (and I updated the cumulative to account for that). The calculation used EDATE(R$1,-12) for 1 year instead of -24 for the 2 years you want just so we could actually see that it works. I hope that helps.