HOW TO CALCULATE NUMBER OF WEEKS BETWEEN TWO GIVEN DATES(MAY BE .

W

WARRENCHERYL

What is the formula for calculating the number of weeks between two given
dates which may be in different years eg 10.01.2002 and 14.05.2004
 
A

Arvi Laanemets

Hi

=INT((Date2-Date1)/7)
gives the number of full weeks
=MOD(Date2-Date1,7)
gives number of remaining days
 
Top