Rounding up a formula return
I am using the following formula to change a date into a billing quarter.
=MONTH([Year-1/Deliverable-1 Invoice Date]@row) / 3
It works well except for any date in January. That returns a value of .3 (1/3=.3). The system automatically rounds that down to 0 which does not work when trying to display a January date as Q-1.
Feburary returns a value that rounds up to 1 which makes sense since Februaury is in Q-1. All of the other months work as expected.
I have tried to nest a ROUND function in to my formula with no sucsess. Can anyone help me with this. I am thinking its something simple that I am overlooking.
Help Article Resources
Check out the Formula Handbook template!