I have data set up across multiple columns with dates included for each pay date, for example:
Person Pay-1 Date-1 Pay-2 Date-2 Pay-3 Date-3
002 10 1-2008 15 5-2008 30 10-2008
003 10 1-2008 20 4-2008 45 9-2008
004 5 2-2008 14 7-2008 55 8-2008
The sum I want to work would be as so: Sum pay-1 if date-1 is within 2 years of today, sum pay-2 if date-2 is within 2 years of today, etc. and so on to get a final sum value for each person based on when they were paid out in relation to today.
Any help would be MUCH appreciated. Thanks!
Bookmarks