Count the Number of Whole Weeks between Two Dates

To count the number of weeks between two dates, you use the Week Difference function.

The Week Difference function returns the number of whole weeks between two dates. This calculation includes only one endpoint. For example:

the number of weeks until the baby is due = WeekDifference(the current date, the baby's due date)

If the current date is 26/6/2019 and the baby's due date is 25/12/2019, the number of weeks until the baby is due is 26.

Note: The order of the two dates in the function does not affect the result.