End of Quarter UDF

This sheet shows you how to create an end of quarter function and an end of half year function that can be useful in creating quarterly summaries from monthly data. The videos below explain how to roll-up data using the SUMIF or SUMIFS along with the end of quarter function.

.

Function eoqtr(date1)

month_of_date = Month(date1)

If month_of_date = 1 Or month_of_date = 4 Or month_of_date = 7 Or month_of_date = 10 _
 Then eoqtr = WorksheetFunction.EoMonth(date1, 2)

If month_of_date = 2 Or month_of_date = 5 Or month_of_date = 8 Or month_of_date = 11 _
 Then eoqtr = WorksheetFunction.EoMonth(date1, 1)

If month_of_date = 3 Or month_of_date = 6 Or month_of_date = 9 Or month_of_date = 12 _
 Then eoqtr = WorksheetFunction.EoMonth(date1, 0)


End Function


.

 

Videos the Explain how and why to Use End of Quarter

The videos below describe how and why to use the end of quarter function.

 

[wonderplugin_video iframe=”Videos the Explain how and why to Use End of Quarter” videowidth=600 videoheight=400 keepaspectratio=1 videocss=”position:relative;display:block;background-color:#000;overflow:hidden;max-width:100%;margin:0 auto;” playbutton=”https://edbodmer.com/wp-content/plugins/wonderplugin-video-embed/engine/playvideo-64-64-0.png”]

.

 

[wonderplugin_video iframe=”https://www.youtube.com/watch?v=5PVn_gjQNOw” videowidth=600 videoheight=400 keepaspectratio=1 videocss=”position:relative;display:block;background-color:#000;overflow:hidden;max-width:100%;margin:0 auto;” playbutton=”https://edbodmer.com/wp-content/plugins/wonderplugin-video-embed/engine/playvideo-64-64-0.png”]

.

[wonderplugin_video iframe=”https://www.youtube.com/watch?v=0rjzbLGzXq4″ videowidth=600 videoheight=400 keepaspectratio=1 videocss=”position:relative;display:block;background-color:#000;overflow:hidden;max-width:100%;margin:0 auto;” playbutton=”https://edbodmer.com/wp-content/plugins/wonderplugin-video-embed/engine/playvideo-64-64-0.png”]

.