Thread: A function to count the number of weeks between dates?

I noticed that when I checked Excel's built in functions that among the DATE, YEAR, MONTH and NOW...there isn't any for WEEK. Does anybody know of an equivalent function that does this or is there another way of getting two dates to return the number of weeks between them? Thanks in advance.

Hi,

This formula can be used to calculate the number of weeks between two dates:

=INT((EndDate-StartDate)/7)

Note that the functions you mentioned (DATE, YEAR etc...) themselves do not calculate differences between dates. To get the number of years, months and / or days between two dates, use the DATEDIF function.