ROUNDUP not working for ranges in same row

Hi All,

I am trying to achieve the followings:
1. Column M4:Q1, N4:Q2, O4:Q3, P4:Q4 are the Quarters. However, the function =ROUNDUP(MONTH($D$4:$L$4)/3,0) is not working when dates are in the same row D4:L4

Since the above is not working, I cant get what im trying to achieve
2. IF any dates fall from D4:L4, the quarter will be displayed to the Column M4:Q1, N4:Q2, O4:Q3, P4:Q4 respectively.

However, the ROUNDUP is working only if dates are in the same column =ROUNDUP(MONTH($D$4:$D$13)/3,0)

Any help is greatly appreciated. Please find attachment.

Thank-You very much.

it is working in the cols because all the dates are the same. it is not working in the rows because you are putting a RANGE in the arg of the MONTH() function when that is looked at as invalid by excel . see here:

https://support.microsoft.com/en-us/...0-ddba0eba86e8

furthermore, you're attempting to divide the invalid return by 3. that won't work either. see here:

https://support.microsoft.com/en-us/...3-db171d0c42a7

this is my guess.

Hi VBA_php, bebo021999

Thanks for the solutions & make me understood where I went wrong. Issued you both reputations & mark this thread to SOLVED.

Thank-You very much

very nice! take care.