Create year , quarter , month, Week, day, hour

 We often need to do summary reports based on week, month, quarter, year and so on. 

Let's see how to extract these info from time stamp.

For example lets consider 1/1/2021  4:00:00 AM

Hour

=TEXT(A2,"hh")

Day

=TEXT(A2,"dd")

=TEXT(A2,"ddd")

=TEXT(A2,"dddd")

Week

=WEEKNUM(A2)

Month

=TEXT(A2,"mm")

=TEXT(A2,"mmm")

=TEXT(A2,"mmmm")

Quarter

To calculate quarter we will use month info.

=ROUNDUP((MONTH(A2))/3,0)

Some companies use different starting month for quarter need to adjust the month.

Year

=TEXT(A2,"yyyy")