Quote:
Originally Posted by Marcia
Thank you. Tried both formulae and they're perfect. It is my first time to use the FLOOR function.
Edit: In the FLOOR formula, I thought I just need to change the 3 to 1 or 2 just like Arvi's. I was wrong so I will use Arvi's solution.
|
No, the 3 does not need to be changed, that is the advantage... FLOOR with a significance of 3 will ALWAYS return the first month of the quarter (1,4,7,10)