Calculating eligibility dates

  • Thread starter Thread starter PH@tic
  • Start date Start date
P

PH@tic

How do I write a multiple function that will answer the question:

What is the first quarter following the employee's one-year anniversary?
Quarters being: January 1, April 1, July 1, October 1
 
The suggestion doesn't seem to work. I presum the DoH is Date of Hire?

I do have a column that lists the initial hire date. For one employee, the
cell is D3.

Can you suggest a change to the initial suggestion that would allow me to
refer to a cell?

Thanks.
 
The suggestion doesn't seem to work. I presum the DoH is Date of Hire?

I do have a column that lists the initial hire date. For one employee, the
cell is D3.

Can you suggest a change to the initial suggestion that would allow me to
refer to a cell?

Thanks.
Click to expand...

You just change DoH to D3. Then the formula can be copied down the
list of employees.
 
I ended up using what follows and it appears to work. Thanks for all the
help. Now I just need to understand WHY it works! I appreciate the resource.

=IF(ISBLANK(D2),"not yet",DATE(YEAR(D2)+1,INT((MONTH(D2)+2)/3)*3+1,1))
 
Back
Top