How to Format Date To Quarter and Year in Excel | MS Excel Tutorial

preview_player
Показать описание
Your donation will support me to continue to make more tutorial videos!

In Excel, there no built-in formatting that converts date as quarter (plus year). In this quick video, I will show you how you can easily format dates to quarter and year in Excel using simple formula.

Visit my website
Рекомендации по теме
Комментарии
Автор

Thank you for this great explanation. It saves me a lot of time

jonathann
Автор

Simplest formula I have been looking for.

Sbudarh_P
Автор

Simple and the right formulae what I have been looking for Thank you:)

rasheednayakkan
Автор

How would your write the formula to have the year then the quarter?

michaelsmith