RicardoCubed
Board Regular
- Joined
- Jul 10, 2013
- Messages
- 206
- Office Version
- 365
- Platform
- Windows
Looking for a formula to calculate an employees benefit eligibility date once employed. eligibility dates are on a quarterly basis so Jan 1, Apr 1, Jul 1 and Oct 1 are the dates. So if employee starts on 2-1-14, eligibility date would be 4-1-14. Needs to work for 12-31-13 employment date = eligibility date would be 01-01-14. If employee starts on 1-1-14, eligibility date 1-1-14.
Employee Hire Date Eligibility Date
Jonny Jones 2/1/2014 4/1/2014
Ricardo Cubed 5/30/2012 7/1/2012
Harry David 9/15/2014 10/1/2014
Susie Que 12/31/2013 1/1/2014
Newbie Too 1/1/2014 1/1/2014
thanks for any help you can provide!!!
Employee Hire Date Eligibility Date
Jonny Jones 2/1/2014 4/1/2014
Ricardo Cubed 5/30/2012 7/1/2012
Harry David 9/15/2014 10/1/2014
Susie Que 12/31/2013 1/1/2014
Newbie Too 1/1/2014 1/1/2014
thanks for any help you can provide!!!