Hey, folks, I am using a sheet to calculate the quarter based on a date field.
=ROUND(MONTH([EST Close Dates]1) / 3, 0)
However, with no ROUNDUP function, the calculation technically doesn't = the correct values in some cases. For example months Jan - Mar should display 1 however Jan displays 0 February displays 1 and so on.
Any help if someone has done this before would be great. Thanks!
Help Article Resources
Check out the Formula Handbook template!