Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
May be try this:
='HEADLINES FOR ' & 'Q' & Ceil(Month(AddMonths(Today(), -3))/3) &'-' & year(addmonths(today(),-3)) &' -
May be try this:
='HEADLINES FOR ' & 'Q' & Ceil(Month(AddMonths(Today(), -3))/3) &'-' & year(addmonths(today(),-3)) &' -
Ok, that works, what did you change and will the rounding stay the same next quarter? Q4 - 2016?
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?
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)) &' -
T is for my last name Talwar
yeah saw that.
Sharp like a sword.
Yes so the difference was that previously you were ceill and then dividing. and now you are dividing and the ceiling.