Based on Gregorain calendar, every week of a year has a number from 1 to 52, 53 or 54. Use this tag for instance if you want to calculate the weeknumber from a certain date or vice versa. You also might include the date tag. This tag is independent of programming language.
Questions tagged [week-number]
603 questions
0
votes
4 answers
How can I extract the week number from java.util.Date in scala
I already tried to use:
getWeek
getCalendarDate
and I don't want to use Calendar package (because I am using a specific software that don't allow me to use it)
Thanks in advance,
Matan Retzer
- 65
- 1
- 7
0
votes
1 answer
algorithm: get next year date work shift type according week number
I work in 3 shifts, each week different one. The order is morning shift (m), night one (n) and afternoon one (a). The order i fixed, i.e. it never changes, even if one won't work that week.
I created a function to get ISO week number. When I throw…
tukusejssirs
- 564
- 1
- 7
- 29
0
votes
1 answer
Excel VBA : week numbers
I'm using Excel VBA, How can I ?
Input month and year and return all week numbers for this month.
Input a date and get the week number for this date.
Mohammed Zegui
- 83
- 2
- 11
0
votes
1 answer
Weeknum Functions return types Power Query
With the limitations in the Weeknum standard function in Power Query, does anyone have any M-Code with which a function can be invoked to give different Weeknum return types (specifically, in Excel it's be Weeknum (date,14)).
I found this to give me…
James Neil
- 33
- 4
0
votes
1 answer
Read the correct week number from a calendar date
I have below dates in an Excel column, as you can see.
Sprint 1 takes from 10.04 to 21.04 this means 2 weeks and between brackets they are specified week 15 and 16 which is correct but for Sprint 2, who also starts in 10.04 but takes until 05.05 it…
USER7423
- 173
- 1
- 1
- 7
0
votes
2 answers
Conver to ISO week to month date on SQL
I've searched on almost every question but haven't come with what I need, so here it goes:
I need to convert a date in the format of 'yyyyww' (where 'ww' is the iso week of the year) to 'yyyymm' (where 'mm' is the month of the year).
So, for…
PabloRjs
- 23
- 3
0
votes
2 answers
How to get the Starting date and ending date of weeks using week number in my case using SQL Server?
I already find to get the week number but, that shows the date in different way.
Actually When I check the week number for the Date of
select datepart(wk,'2016-01-02') //Saturday
output: 1
select datepart(wk,'2016-01-03') //Sunday
output:…
Liam neesan
- 2,282
- 6
- 33
- 72
0
votes
3 answers
Excel : Weeknumber within month with criteria
I'm trying to make a formule to calculate the weeknumber within a week but with certain criteria. The week always starts on a monday. But if the thursday of that week is in the next month, then that weeknumber is part of the next month.
[enter image…
Innerv1sion
- 5
- 1
- 3
0
votes
1 answer
Distribute value equally over weeks by start- and end-date
I want to distribute a certain value (D4:D6) equally over the week-numbers (E3:J3) by its start- and end-date (B4:C6), as shown in the example.
A formula/vba script should do the following things:
Check which week-number the start- and end-date…
Falk
- 86
- 1
- 10
0
votes
2 answers
Get week number where the weeks start counting from first Monday in April until the first Monday next April in PHP
I am trying to achieve the following:
For reporting purposes our week numbers begin from the first Monday in April each year.
I am creating a calendar using PHP in the following format:
M T W T F S S
At the end of each row of that month I want to…
Michael
- 1,769
- 2
- 12
- 21
0
votes
0 answers
How to display a 2-digit year + ISO week in PDF using JavaScript
I would like to have a form field in a PDF that autofills with the date formatted as "YYWK", where YY is the 2-digit year and WK is the ISO week. I have seen code here on how to display the ISO week (https://weeknumber.net/how-to/javascript). What I…
Ashley L.
- 1
- 1
0
votes
2 answers
MSSQL - How to divide each month into 4 weeks?
I have a query that is close to doing what I need:
select *
from
(
select DATEPART (YEAR, order_date) as theYear,
DATEPART (WEEK, order_date) as theWeek,
SUM (order_totalPrice) as totalSales
…
Billy Turtleneck
- 55
- 9
0
votes
1 answer
how to show number of week and show date range in php
How to show list of week and date range of week in 1 year using php
Like this:https://www.epochconverter.com/weeks/2017
Yanno Dwi Ananda
- 3
- 1
0
votes
1 answer
Using awk, how to convert dates to week and quarter?
Using awk, how to convert dates (yyyy-mm-dd) to week and quarter (first day of week set to monday)?
Input:
a;2016-04-25;10
b;2016-07-25;20
c;2016-10-25;30
d;2017-02-25;40
Wanted…
Markus
- 69
- 6
0
votes
3 answers
Date convert to week number
Hi Not sure if anyone can help me.
How can I convert current date to week number in a batch scripting?
I only know how to generate current date from my pc. %DATE%
eg. 3/16/2017 is week 11
gonzalloe
- 313
- 3
- 7
- 22