how to calculate no of weeks between two dates in excel?
To determine how many weeks elapsed between two dates, we can use a simple formula to find the number of days between the dates, then divide by 7. The formula will return a decimal number. We can change the number format to a Fraction to display the number of days.