Calculate eligibility/enrollment date
Hi,
Just a little warning, if you are elegible at 90 days not after 90 days then
you had better revisit JE's formula for a date link January 2, 2008. It will
return 7/1/08 when it should return 4/1/08.
--
If this helps, please click the Yes button
Cheers,
Shane Devenshire
"PH@tic" wrote:
We've changed our rules for calculating eligibility date for certain benefits
from 1 year of service to 90 days of service. Yet even after 90 days,
enrollment cannot be until Jan 1, Apr 1, Jul 1, Oct 1 of any year. How can I
adjust the following formula to calculate 90 days plus the time to the next
interval above to arrive at an appropriate eligibility/enrollment date?
=IF(ISBLANK(D3),"not yet",DATE(YEAR(D3)+1,INT((MONTH(D3)+2)/3)*3+1,1))
|