To find the week’s number between two dates in Google Sheets, we will consider an example of a planned business trip from 20th July 2024 to 30th Dec 2024, as shown below. Let us apply the formula we used in example 3 to find the difference between the two dates and divide the difference by 7. So, we have 7 days a week. We get the output shown below. Let us change the format of the resulting cell to fractions. First, select cell C2 à select the “Format” tab à click the “Number” option right arrow à scroll down and click the “Custom number format” option, as shown below. Next, the “Custom number format” window opens. Here, select the required fraction format and click the “Apply” button, as shown below. Finally, we have the number of weeks in fractions now.