![]() If you want to create the next week date range. ![]() Now the first week date range has been created. ![]() Then in cell E6, use below formula to create the date range of first week: In cell D6, type below formula to get the end date of the first week: In cell C6, type below formula to get the start date of the first week: If you want to get a series of weeks based on the given date, you can do as below: : connects the start date and end date to get the date range. Here it converts the date to the text format M/D/YYYY, and you can change the format as you need. TEXT function: converts number to a text in a specific text format. Here ROWS($A$1:A1)*7 returns 1*7.Īnd the formula $C$2+ROWS($A$1:A1)*7 gets the end date of the week. ROWS function: returns the number of row. In cell C3 is the date that you want to create the weekly date range starting from, please use below formula: =TEXT(C2, "M/D/YYYY")&" - "&TEXT($C$2+ROWS($A$1:A1)*7, "M/D/YYYY") Syntaxt and Arguments Start_date:the date that starts a week.ĭate_format:a date format that you want to display in the weekly date range. Generic formula: TEXT(start_date, "date_format")&" - "&TEXT(start_date+ROWS($A$1:A1)*7, "date_format") If you want to follow along with this tutorial, please download the example spreadsheet. In this tutorial, it provides a formula to quickly get the weekly date range in Excel. Here is a given date, and you may want to create the weekly date as above screenshot shown based on the given date.
0 Comments
Leave a Reply. |