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.
Bookmarks