This week is ...
Week 22 is from Monday May 30, 2016 until (and including) Sunday June 5, 2016.
Week number according to the ISO-8601 standard, weeks starting on Monday. The first week of the year is the week that contains that year's first Thursday (='First 4-day week'). The highest week number in a year is either 52 or 53. This year has 52 weeks.
This is not the only week numbering system in the world, other systems use weeks starting on Sunday (US) or Saturday (Islamic).
Where the return type '21' is ISO-8601 (week starting on Monday).
In Excel 2007 try WEEKNUM(TODAY(),2) (2=week starting Monday). Just WEEKNUM(TODAY()) will show the week number with weeks starting on Sunday (return type = 1).
$weekNumber = date("W");
date("W", epoch) for other week numbers. Remember to use capital 'W' not 'w'.
my $weekNumber = POSIX::strftime("%V", gmtime time);
Replace time with other epoch/UNIX timestamps for other week numbers.
Calendar now = Calendar.getInstance(); now.get(Calendar.WEEK_OF_YEAR);
DateTime test_date = DateTime.Now; double week_of_year = Math.Ceiling(Convert.ToDouble(test_date.DayOfYear) / 7);
Replace now() with other dates eg.
(You can also use the WEEK function with mode=3
SELECT * FROM EXTRACT(WEEK from current_date())
SELECT DATEPART( wk, GETDATE() )
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)
[NSString stringWithFormat:@"Week %d", [calendar ordinalityOfUnit:NSWeekCalendarUnit inUnit:NSYearCalendarUnit forDate:date]];
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
week_number = Time.now.strftime("%U")
Replace Time.now with Time.local(year,month,day) for other dates.
%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)
Returns the ISO-8601 week number.
Other formats under 'Ruby'. More details on Kernel.org
Current_week = os.date("%V")
Formats: see formats under 'Ruby'.
Get-Date -UFormat %V
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!
Comments and questions
Time zone converter
Epoch timestamp list
Unix hex timestamp
Seconds/days since year 0
Routines by language
Epoch in C
Epoch in MySQL
Epoch in PERL
Epoch in PHP
Weeks by year
Days by year
between two dates
Comments & questions
Este sitio en Español
Character Set Tools