Google Search

Custom Search

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")










No comments:

Post a Comment

 

blogger templates | Make Money Online

Google Analytics Alternative ExpiresDefault access plus 1 year