Google Sheets Get Number of Weeks Between Dates Fractional Days Function Example Tutorial

In Google Sheets you can get the number of whole weeks between two dates using the DAYS and ROUNDDOWN function.
You can also get the fractional days after the whole weeks.
A method to get such days is to use a simple mathematical calculation. For more info on DAYS and ROUNDOWN please refer to their separate tutorials whose links are given below. ------------------------------------- How to Use DATE and DAYS in Google Sheets? Here is the link to the step-by-step video tutorial on the DATE and DAYS function: ------------------------------------- How to Use ROUND ROUNDUP and ROUNDDOWN in Google Sheets? Get to know more about these three functions with this step-by-step video tutorial: ------------------------------------- How To Create a Fixed Deposit FD Maturity Amount Calculator in Google Sheets? Heres the link to the step-by-step video tutorial on creating the calculator: ------------------------------------- The steps to get the number of weeks between two dates using Google Sheets are: 1.
Get the Number of Days between Two Dates Use the DAYS function and get the number of days between the two dates.
The format of the DAYS function formula is: DAYSend_date start_date Input each of the two dates in the MMDDYY format. Example DAYS111121 010224 The DAYS function returns 782 which is the number of days between the two dates. 2.
Divide the Number of Days by 7 Divide the number returned by DAYS by 7 to get the whole weeks in the number of days. With reference to above example the result of dividing 782 by 7 is 111.71. 3.
Round Down the Number To get the number of whole weeks in the number of days round down the result of the division made in Step 2.
For this task use the ROUNDDOWN function. The format of the ROUNDDOWN function formula is: ROUNDDOWNvalue places Example ROUNDDOWN111.71 The function returns 111. TIP: Combine the division step with step 3 if you wish to avoid one additional step.
The formula that combines the division and round down tasks is: ROUNDDOWN7827 4.
Get the Number of Fractional Days. This step is optional.
Use this step only if you want to get the number of fractional days after the whole weeks.
A method to get the fractional day is to subtract the result of multiplication of 111 whole weeks by 7 days in a week from the number of days between dates. Example 782-1117 The above formula returns 5 which is the fractional days after the whole weeks. Take a look at this video tutorial which gives the steps to use the Google Sheets DAYS and ROUNDDOWN functions and a mathematical formula to get the number of whole weeks and fractional days after the whole weeks with an example.