Get Quarter from a Date / Quick Formula / Microsoft Excel

preview_player
Показать описание
// Sample File \\

// Free E-Book \\

// Let's Connect \\

// About ExcelChamps \\

#ExcelTips #LearnExcel #ExcelTutorial #Excel

//Ending Music Credit\\
Рекомендации по теме
Комментарии
Автор

Cool Tips. Comes in handy for Quarterly reports, etc. Thank You Puneet.

gmMJ
Автор

A shorter (and easier) formula is as follows: =ROUND.UP(MONTH(A1)/3, 0) and you can always put the "Q-"& in front of this formula 🙂

larsfriis