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)
=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")
ExpiresDefault access plus 1 year
Creating views by year, quarter, month, week, day, and hour helps organize data efficiently. It's a bit like managing switch sigpatches keeping everything in the right place ensures smooth performance.
ReplyDelete