How show the week number by month, and not by year?
In this tip, we are going to explore:
How show the week number by month, and not by year?
All explanations are simple and to the point.
#Shorts #GoogleForEducation #GoogleWorkspace #GoogleSheets
Feel free to make your copy of this spreadsheet template:
https://docs.google.com/spreadsheets/...
Useful Link:
Google Workspace Tutorial:
/ googleworkspacetutorial
Ben Collins (Google Developer Expert & Data Analytics Instructor)
https://www.benlcollins.com/
Google Sheets training:
https://support.google.com/a/users/an...
The Playlist link:
• The most useful Google Apps Tips and ...
Follow us on Pinterest:
https://www.pinterest.it/GoogleWorksp...
We have this date: 29 Nov 2022
Our mission is to find its week number by month.
It's in the fifth week in the Nov month.
ISOWEEKNUM function treats Monday as the first day of the week.
= ISOWEEKNUM("29 Nov 2022")
It returns 48 for this date
Result: 48
We use the DATE function to get the number of weeks for the first day of the month.
=ISOWEEKNUM(DATE(YEAR("29 Nov 2022"),MONTH("29 Nov 2022"),1))
We extract the year.
And the month.
For the day, type: 1
= ISOWEEKNUM("29 Nov 2022") - ISOWEEKNUM(DATE(YEAR("29 Nov 2022"),MONTH("29 Nov 2022"),1)) + 1
It returns 44 for this date
We subtract the first formula from the second, then we add 1.
The mission is done.
