Calculating eligibility dates

[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

 

[Bob Phillips]

=DATE(YEAR(DoH),INT((MONTH(DoH)+2)/3)*3+1,1)

and format as mmm d

 

[PH@tic]

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.

 

[Spiky]

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.

You just change DoH to D3. Then the formula can be copied down the
list of employees.

 

[PH@tic]

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))