What week of the year is it?

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:

datetime.date.today().isocalendar()[1]

In Java:

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:

SELECT WEEKOFYEAR(NOW())

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:

WEEKNUM()

In Microsoft Excel:

ISOWEEKNUM(TODAY())