Stack Overflow
Stack Overflow

Questions tagged [week-number]

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.

603 questions
0
votes
1 answer

Calculate Week of The Month with Straddling Weeks - Excel

I am trying to calculate the weeks of the month, 1-4 or 1-5, where the calendar week that contains the first calendar day of the month is always week 1. So for example, February 1, 2018 falls on a Thursday so the dates Monday January 29 - Sunday…
Beth
  • 3
  • 1
  • 3
0
votes
1 answer

First Day of Week is set to Sunday instead of Monday in Oracle

I have the following query: SELECT forecastDate, to_char(to_date(forecastDate),'WW') AS WEEK_NUMBER FROM ACT_FORECAST Which give me this result : forecastDate | WEEK_NUMBER 14/07/2017 28 15/07/2017 28 16/07/2017 29 But in my region the…
AnthonyDa
  • 493
  • 15
  • 34
0
votes
1 answer

counting how many weeks of the year date ranges cover/occur in

I have a number of records in a sheet, each with a start and end date. Each line has a record number, with some lines having record numbers the same as other lines (The sheet lists cases and dates that case was used. Some cases have 1 line only,…
Natalie Hunt
  • 23
  • 5
0
votes
2 answers

VBA: If statement to replace week number with text

In my workbook "isum", I have the week number figured out by a WEEKNUM formula (right now is week 27) listed on column X under the label Week#. The worksheet is called "Orders" with data to see what orders are late. I am struggling to create an…
user10003190
0
votes
1 answer

Entering formula into column range but select method of range class failed

please let me know if I need to be more specific. I am entering a weeknum() formula on my workbook isum on sheet stock. I want this formula to be evaluated for everything in the "X" column starting at row 2 since the top row will be a label. I used…
user10003190
0
votes
1 answer

Fiscal year starts in April but I want to use ISO week numbers 14 of 2018 calendar year to week 13 of 2019 calendar year

I am creating a gantt chart in excel for my plan. My formula determines the start week number and end week number, and displays "1" in a cell corresponding for each week number in a timeline. My challenge is how to use this logic when my fiscal year…
Nikita_Che
  • 7
  • 2
0
votes
0 answers

Determine the calendar week for a given Date

I tried to search for "Calculating the Week for a given Date" and could not find accurate solution in a easier way. Here is what I have tried: Let's assume the date specified is 'd' getWeekOfDay: function(d){ var date1 = new Date(d.getFullYear(),…
Arvind
  • 1
  • 3
0
votes
2 answers

Extract part of sheet name to cell

Part of my sheet name is the date (the part in between the dashes) and I'd like to create a macro that uses the sheet name to give me the number of the week in cell H1 of the sheet. Sheet name: BO-D58C2_-20180507-13260132 I would like to extract in…
Jthomson
  • 1
  • 2
0
votes
1 answer

Know the week number of a month in bigquery

I want to know the week number of a month for a date in bigquery standard sql.In PostgreSQL if I write: select To_char(current_date, 'YYYY-MM-W')
It works for the date '25-04-2018' as 2018-04-4. Here 2018 is the year, 04 is the month and 4 is…
Sweta
  • 63
  • 3
  • 13
0
votes
1 answer

getting the date from a a input "week" control

I have a input control in my HTML file set week? I'd like to allow a user to use the control to set week they want. I will then need to get the Julian of that day so I can populate my grid with the 5 workdays of that week. I can't seem to get the…
Richard Bernstein
  • 361
  • 5
  • 20
0
votes
2 answers

Excel VBA to calculate week number from cell date and display

I have an excel vba sub that sends email reminders every 14 days based on a date in a cell. I would also like to include the week number since the date in the cell to todays date. E.g. Cell date 1st April to present day 28th April to return 4 weeks.…
Paul C
  • 15
  • 4
0
votes
2 answers

How to align grid and whisker of box plot with ggplot2?

I'm plotting hourly data grouped by week number on the basis of this answer: https://stackoverflow.com/a/48196838/5235575 My example shows the first two weeks of 2016 starting with Monday 01-04-2016 00:00 and ending with Sunday 01-17-2016 23:00 How…
LarsVegas
  • 65
  • 6
0
votes
1 answer

Week Number in Teradata from Monday to Sunday

In Teradata SYS_CALENDAR.CALENDAR for year 2018 , the WEEK_OF_YEAR is starting from Sunday to Saturday. But I wanted WEEK_OF_YEAR to start from Monday to Sunday as 1. so 01-Jan-2018 to 07-Jan-2018 WEEK_OF_YEARwill be 1 : : and 31-Dec-2018…
Prasanna Nandakumar
  • 4,295
  • 34
  • 63
0
votes
1 answer

How to forecast on Excel based on weeks

I have this data ¦Year-Week¦Sales¦Forecast¦ ¦2015-42 ¦ 7 ¦ ¦ ¦2015-43 ¦ 8 ¦ ¦ ¦2015-44 ¦ 2 ¦ ¦ ¦2016-45 ¦4276 ¦ ¦ ¦2016-46 ¦ 876 ¦ ¦ ¦2016-47 ¦ 7 ¦ ¦ ¦2016-48 ¦ 52 ¦ ¦ ¦2016-49 …
VS1SQL
  • 135
  • 2
  • 13
0
votes
2 answers

Extract weeknumber in R using system1 from WEEKNUM function in ms-excel

I want to extract weeknumber in R using the same system 1 as used by WEEKNUM function in Excel. Please refer to the image below I have explored all the available option to extract weeknumber from date in R but nothing is fulfilling my…
learner
  • 828
  • 2
  • 19
  • 36
1 2 3
…
40 41