Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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)) |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Trying to calculate end date using order date and lead time variab | Excel Worksheet Functions | |||
Calculating eligibility dates | Excel Worksheet Functions | |||
Eligibility Dates | Excel Worksheet Functions | |||
Statistics Plus Minus Enrollment | Excel Worksheet Functions | |||
Auto calculate for date + days forward to yield new date | Excel Worksheet Functions |