bearcub
Well-known Member
- Joined
- May 18, 2005
- Messages
- 711
- Office Version
- 365
- 2013
- 2010
- 2007
- Platform
- Windows
I'm preparing a schedule of people who are going to be receiving commission advances (draws).
They are eligible to receive the draw the following month of their employee (we pay commissions one months in arrears so if they start in April their first draw would be paid in May).
In one column I have their hire date.
In another column I have a sumif formula to calculate the amount of advances they accumulated year to date (I want the formula to "turn on" when they are supposed to receive this first draw).
How would I tell the Formula to look one month ahead of the hire date to start calculating the draws that are being paid? The though just occurred to me that I could the use the EoMonth function. Would this work?
Michael
They are eligible to receive the draw the following month of their employee (we pay commissions one months in arrears so if they start in April their first draw would be paid in May).
In one column I have their hire date.
In another column I have a sumif formula to calculate the amount of advances they accumulated year to date (I want the formula to "turn on" when they are supposed to receive this first draw).
How would I tell the Formula to look one month ahead of the hire date to start calculating the draws that are being paid? The though just occurred to me that I could the use the EoMonth function. Would this work?
Michael
