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

G

Guest

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top