(A2-INT(A2\/7)*7) & IF((A2-INT(A2\/7)*7)=1, \" day\", \" days\")<\/code><\/pre>\n\n\n\nIn this second part of the formula, the value in cell A2 is divided by 7 and the result is rounded to an integer. The integer value is then multiplied by 7 to convert it to the number of days. The product is subtracted from the number in cell A2 resulting in the number of days that could not add up to a week.<\/p>\n\n\n\n
The result is later passed to the IF function. If the result is equal to 1, the IF function returns \u201cday\u201d otherwise it returns \u201cdays.\u201d The number of days is then joined to the value returned by the IF function by the ampersand (&) operator.<\/p>\n\n\n\n
The result of the first part of the formula is then joined to the result of the second part of the formula using the ampersand (&) operators to display the number of weeks and a number of days.<\/p>\n\n\n\n
Example 3: ROUNDDOWN and IF function to convert days to weeks and days<\/h3>\n\n\n\n In Example 1, we used the ROUNDDOWN and IF functions to convert the number of days to weeks and decimals. In this example, we use the functions to convert the number of days to weeks and days.<\/p>\n\n\n\n
We use the following subset of our dataset:<\/p>\n\n\n\n <\/figure>\n\n\n\nWe use the following steps:<\/p>\n\n\n\n
\nSelect cell B2<\/strong> and type in the following formula:<\/li>\n<\/ol>\n\n\n\n=ROUNDDOWN(A2\/7,0) &IF(ROUNDDOWN(A2\/7,0)=1, \" week\", \" weeks\") & \" and \" & (A2-ROUNDDOWN(A2\/7,0)*7) & IF((A2-ROUNDDOWN(A2\/7,0)*7)=1, \" day\", \" days\")<\/code><\/pre>\n\n\n\n <\/figure>\n\n\n\n\nPress the Enter key and double-click or drag down the fill handle to copy the formula down the column.<\/li>\n<\/ol>\n\n\n\n <\/figure>\n\n\n\nExplanation of the formula<\/strong><\/p>\n\n\n\nROUNDDOWN(A2\/7,0) &IF(ROUNDDOWN(A2\/7,0)=1, \" week\", \" weeks\")<\/code><\/pre>\n\n\n\nIn this first part of the formula, the value in cell A2 is divided by 7. The ROUNDDOWN function rounds the result to an integer with 0 (zero) decimal places.<\/p>\n\n\n\n
The integer value is passed to the IF function in the next part of the formula. If the integer value is equal to 1 the IF function returns “week” otherwise it returns “weeks.” The values returned by the ROUNDDOWN and IF functions are then joined by the ampersand (&) operator.<\/p>\n\n\n\n
(A2-ROUNDDOWN(A2\/7,0)*7) & IF((A2-ROUNDDOWN(A2\/7,0)*7)=1, \" day\", \" days\")<\/code><\/pre>\n\n\n\nIn this second part of the formula, the integer value returned by the ROUNDDOWN function is multiplied by 7 to convert it to a number of days. This number of days is subtracted from the value in cell A2.<\/p>\n\n\n\n
The result is the balance number of days that could not add up to a week. In the next part of the formula, the number of days that could not add to a week is passed to the IF function. If the number is equal to 1 the IF function returns “day” otherwise it returns “days.”<\/p>\n\n\n\n
The result of the first part of the formula is finally joined to the result of the second part of the formula using the ampersand (&) operators to display the number of weeks and days.<\/p>\n\n\n\n
Example 4: INT, IF, and MOD functions to convert days to weeks and days<\/h3>\n\n\n\n In this example we use INT<\/strong>, IF<\/strong>, and MOD<\/strong> functions to convert a number of days to weeks and days in Excel using the following subset of our dataset:<\/p>\n\n\n\n <\/figure>\n\n\n\nWe use the following steps:<\/p>\n\n\n\n
\nSelect cell B2 and type in the formula:<\/li>\n<\/ol>\n\n\n\n=INT(A2\/7) & IF(INT(A2\/7)=1, \" week\", \" weeks\") & \" and \" & MOD(A2,7) & IF((MOD(A2,7))=1, \" day\", \" days\")<\/code><\/pre>\n\n\n\n <\/figure>\n\n\n\n\nPress the Enter key and double-click or drag down the fill handle to copy the formula down the column.<\/li>\n<\/ol>\n\n\n\n <\/figure>\n\n\n\nExplanation of the formula<\/strong><\/p>\n\n\n\nINT(A2\/7) & IF(INT(A2\/7)=1, \" week\", \" weeks\")<\/code><\/pre>\n\n\n\nIn this first part of the formula, the value in cell A2 is divided by 7 and the INT function rounds the result to an integer. The integer is then passed to the IF function. If the integer is equal to 1, the IF function returns “week ” otherwise it returns “weeks. “<\/p>\n\n\n\n
The MOD<\/strong> function is used In the second part of the formula. The MOD<\/strong> function returns the remainder after a number is divided by a divisor. Its syntax is MOD(number, divisor)<\/strong>. The number<\/strong> argument is required and it is the number for which we want to find the remainder. The divisor <\/strong>argument is required, and it is the number by which we want to divide the number.<\/p>\n\n\n\nMOD(A2,7) & IF((MOD(A2,7))=1, \" day\", \" days\")<\/code><\/pre>\n\n\n\nThe MOD function returns the remainder when the value in cell A2 is divided by 7. This result is passed to the IF function. If the result is equal to 1 the IF function returns “day” otherwise it returns “days.” The values returned by the MOD and IF functions are joined or concatenated by the ampersand (&) operator.<\/p>\n\n\n\n
The result of the first part of the formula is finally joined to the result of the second part of the formula using the ampersand (&) operators to display the number of weeks and days.<\/p>\n\n\n\n
Conclusion<\/h2>\n\n\n\n Sometimes we may want to convert the number of days in our Excel worksheets into weeks.<\/p>\n\n\n\n
In this tutorial, we have given four examples to explain how we can use the INT<\/strong>, IF<\/strong>, MOD,<\/strong> and ROUNDOWN<\/strong> functions to convert the number of days to weeks in Excel.<\/p>\n","protected":false},"excerpt":{"rendered":"Sometimes we may want to convert the number of days into weeks in Excel summary reports. Convert Number of Days to Weeks in…<\/p>\n","protected":false},"author":5,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[23],"tags":[170,190],"yoast_head":"\n
Convert Number of Days to Weeks in Excel<\/title>\n \n \n \n \n \n \n \n \n \n \n \n \n \n \n\t \n\t \n\t \n