![]() ![]() The second criteria A12 applies to the range D2:D8. So the function will filter out the records that correspond to “1” as the week. ![]() The Criteria_range1 is B2:B8, with the criteria1 set to cell B10. ![]() ![]() We have set the sum_range to C2:C8 (Bills). For the return_type as 13 and 14, the day increments when there comes a Wednesday (E7) and Thursday (F8) respectively.Īs a result, the WEEKNUM function of Excel has returned 1332 to be the sales of the first week for label A.Įxplanation – The SUMIFS formula is used to get the sum of the range with the criteria specified. The boxes indicate the days at which the week number is incremented by 1. Once it comes a Tuesday on 04-01-2021 (D6), the formula starts a new week there and the date falls in the second week of the month. For the dates before 04-01-2021, the formula returns the week number for them to be 1. Similarly, when we passed the return_type function argument to be 12, the new week starts on Tuesday. So the formula returns 2 (C5) as the week number for the dates between 0 and 08-01-2021. This is so because there is a Monday on that date and the week number is incremented by 1. When we copy the formula for the rest of the cells in column C, there comes a change in the week number for the date 04-01-2021. As a result, the formula has returned the date 01-01-2021 to be in the 1st week of the year. In this section of the blog, we will do some examples to learn the usage of the WEEKNUM formula.Īs a result, the formula returns the week number for 01-01-2021, but with different values of return_type argument.Įxplanation – In the first formula, we have passed A2 as the date and 11 as the return_type function argument.
0 Comments
Leave a Reply. |