My rounding on quarter expression does'nt work

[Anonymous]

Hi,

This

='HEADLINES FOR ' & 'Q' & ceil(month(AddMonths(today(),-3)))/3 &'-' & year(addmonths(today(),-3)) &' - 

looked like this before October 2016

HEADLINES FOR Q2 - 2016 -

If now looks like

HEADLINES FOR Q2.33333333333333333 - 2016 -

What's gone wrong after an extra month was added?

Regards

LAK

[sunny_talwar · Accepted solution]

May be try this:

='HEADLINES FOR ' & 'Q' & Ceil(Month(AddMonths(Today(), -3))/3) &'-' & year(addmonths(today(),-3)) &' -

[Anonymous]

Ok, that works, what did you change and will the rounding stay the same next quarter? Q4 - 2016?

[Anonymous]

Does the 'T' in Sunny T, stand for Turbo as you are so fast with your answers.

I've got a unanswered question from around 10 days ago, have you had a look?

[sunny_talwar]

Just changed the placement of one of the closing parenthesis

From

='HEADLINES FOR ' & 'Q' & ceil(month(AddMonths(today(),-3)))/3 &'-' & year(addmonths(today(),-3)) &' -

To

='HEADLINES FOR ' & 'Q' & ceil(month(AddMonths(today(),-3))/3) &'-' & year(addmonths(today(),-3)) &' -

[sunny_talwar]

T is for my last name Talwar

[Anonymous]

yeah saw that.

[Anonymous]

Sharp like a sword.

[sunny_talwar]

Yes so the difference was that previously you were ceill and then dividing. and now you are dividing and the ceiling.