Calculate # of remaining quarters

[DashboardNovice]

I am trying to determine the number of remaining quarters in 2016 based on a person's hire date.

The answers I am trying to get are in green in column F.

If they were hired before 01.01.2016, then the answer should be 4. The count should start in the quarter they were hired in, i.e. if they were hired on the first or last day of any quarter or any date in between, then the current quarter would be 1, followed by the next quarter, etc.

I can determine the current quarter, (1-4), but I would have to "invert" the results so that they come out as (4-1).

Is there a function that can do this?

 

[PCosta87]

I am trying to determine the number of remaining quarters in 2016 based on a person's hire date.

The answers I am trying to get are in green in column F.

If they were hired before 01.01.2016, then the answer should be 4. The count should start in the quarter they were hired in, i.e. if they were hired on the first or last day of any quarter or any date in between, then the current quarter would be 1, followed by the next quarter, etc.

I can determine the current quarter, (1-4), but I would have to "invert" the results so that they come out as (4-1).

Is there a function that can do this?

Hi,

Not really sure I understood but please take a look at the attached file.
There I used the always handy INDEX/MATCH formula (highlighted yellow) to determine how many quarters are left according to your criteria.

Hope it helps

 

[bosco_yip]

Maybe……….

In F6, formula copy down :

=IF(C6<42370,4,5-ROUNDUP(MONTH(C6)/3,0))

Regards