This week is ...

Week 45

Week 45 is from Monday, November 4, 2024 until (and including) Sunday, November 10, 2024.

Programming routines

Microsoft Excel / LibreOffice Calc

=ISOWEEKNUM(TODAY())
			or (in older versions):
			=WEEKNUM(TODAY(),21)

Where the return type '21' is ISO-8601 (week starting on Monday).

In Excel 2007 your best choice is WEEKNUM(TODAY(),2) (2=week starting Monday).
WEEKNUM(TODAY()) will show the week number with weeks starting on Sunday (return type = 1).

Google Docs Spreadsheet

=WEEKNUM(TODAY();21)

Type (here '21') is compatible with Excel/LibreOffice, 21 is ISO-8601

PHP

$weekNumber = date("W"); 

or date("W", epoch) for other week numbers. Remember to use capital 'W' not 'w'.

Python

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

PERL

my $weekNumber = POSIX::strftime("%V", gmtime time);

Replace time with other epoch/UNIX timestamps for other week numbers.

Java

			Calendar now = Calendar.getInstance();
			now.get(Calendar.WEEK_OF_YEAR);
            

Use WEEK_OF_YEAR in the Calendar class.
More info on Stack Overflow

JavaScript

			Date.prototype.getWeek = function () {
			    var target  = new Date(this.valueOf());
			    var dayNr   = (this.getDay() + 6) % 7;
			    target.setDate(target.getDate() - dayNr + 3);
			    var firstThursday = target.valueOf();
			    target.setMonth(0, 1);
			    if (target.getDay() != 4) {
			        target.setMonth(0, 1 + ((4 - target.getDay()) + 7) % 7);
			    }
			    return 1 + Math.ceil((firstThursday - target) / 604800000);
			}

			var d= new Date();
			alert(d.getWeek());
            

Extend the Date class using the above code.

C#

See the ISO-8601 update on Stack Overflow

MySQL

SELECT WEEKOFYEAR(NOW())

Replace now() with other dates eg. SELECT WEEKOFYEAR('2020-02-20');
(You can also use the WEEK function with mode=3 select week(now(),3))

PostgreSQL

SELECT * FROM EXTRACT(WEEK from current_date())

MS SQL

SELECT DATEPART( wk, GETDATE() )

Oracle

SELECT to_char(sysdate, 'IW') FROM DUAL 

IW: Week of year (1-52 or 1-53) based on the ISO-8601 standard.
WW: Week of year (1-53) where week 1 starts on the first day of the year and continues to the seventh day of the year (Mostly NOT used)

iSeries SQL

SELECT WEEK(NOW())  from sysibm.sysdummy1

iPhone/Mac

[NSString stringWithFormat:@"Week %d", 
  [calendar ordinalityOfUnit:NSWeekCalendarUnit inUnit:NSYearCalendarUnit forDate:date]];
            

iPhone/iOS/Swift

let gregorian = NSCalendar(calendarIdentifier: NSCalendarIdentifierGregorian)!
gregorian.firstWeekday = 2 // Monday
gregorian.minimumDaysInFirstWeek = 4
let components =
    gregorian.components(.WeekOfYearCalendarUnit | .YearForWeekOfYearCalendarUnit, fromDate: date)
let week = components.weekOfYear
let year = components.yearForWeekOfYear
            

R

lubridate::week()

Ruby

week_number = Time.now.strftime("%U")

Replace Time.now with Time.local(year,month,day) for other dates.
Formats:
%U - Week number of the year, starting with the first Sunday as the first day of the first week (00..53)
%V - Week number of year according to ISO-8601 (01..53)
%W - Week number of the year, starting with the first Monday as the first day of the first week (00..53)

Go

year, week := time.Now().ISOWeek()

Linux/Unix shell (bash)

date +%V 

Returns the ISO-8601 week number.
Other formats under 'Ruby'. More details in the Linux Programmer's Manual

Lua

Current_week = os.date("%V")

Formats: see formats under 'Ruby'.

Windows PowerShell

            Get-Date -UFormat %V
            # or
            "{0:d2}" -f ($(Get-Culture).Calendar.GetWeekOfYear($(Get-Date), 
              [System.Globalization.CalendarWeekRule]::FirstFourDayWeek, [DayOfWeek]::Monday))
                        

X++ (Microsoft Dynamics AX)

            int weeknum;
            weeknum = weekOfYear(today());
            

C/AL (Microsoft Dynamics NAV):

MESSAGE(FORMAT(CALCDATE('CW', TODAY), 0, '<week>'));

Thanks to everyone who sent me corrections and updates! Contact us: [email protected]