Forum Discussion
Solved
How to auto-populate the weeks of the year
How to auto-populate the weeks of the year with their beginning and ending date (Ex: 1/2 - 1/8) and autofill
Hello cmoulthrop,
sorry for misunderstanding your question, not really good in English.
anyway... based on your image.the sample is on the attached.
Hello cmoulthrop,
Using a single date, you can determine the week number of the year
Assuming you have a date in A2.
enter this formula on B2: =WEEKNUM(A2)
WEEKNUM function - syntax
The WEEKNUM function is used in Excel to return the week number of a specific date in the year (a number between 1 and 54). It has two arguments, the 1st is required and the 2nd is optional:
=WEEKNUM(serial_number, [return type])
- Serial_number - any date within the week whose number you are trying to find. This can be a reference to a cell containing the date, a date entered by using the DATE function or returned by some other formula.
- Return_type (optional) - a number that determines on which day the week begins. If omitted, the default type 1 is used (the week beginning on Sunday).
source: WEEKNUM function
Rodrigo_ Thank you, sorry if there was confusion in my question. I am trying to have excel populate the date ranges for me.
