We are currently in the week 14 of the year 2020.
Accordingly to ISO-8601 standard, weeks start on Monday until Sunday.
This simple web page uses a PHP script to display the week number of the current year. The PHP script runs a
echo date("W"); routine to display the week number from the current date. It is pretty simple in PHP, but there are many other languages supporting similar routines.
In Python you can run:
Calendar now = Calendar.getInstance(); now.get(Calendar.WEEK_OF_YEAR);
If you need to generate a query in MySQL to display the week number, then you can run the following SELECT query:
Google Sheets also have a function that will display the week number in a cell. To get the week number in Google spreadsheet, use this formula:
In Microsoft Excel: