D: Return difference in days | 7 days a week, to return days firstly then divides 7 to get the number of weeks |
---|---|
As the formula returns value in date format, you need to format the result to general or number to get the number of weeks |
The end date must be greater than the start date, otherwise the formula will return the error value NUM!.
25M: Return difference in months | As the formula returns value in date format, you need to format the result to general or number to get the number of weeks |
---|---|
D: Return difference in days | The end date must be greater than the start date, otherwise the formula will return the error value NUM! |
M: Return difference in months.
22.
20