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
 

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

Similar Threads

Display weeks from a Milestone 0
Expanding Date Formula 0
Percentage of month passed formula 1
Finding the proper style field and the numbered paragraph value within the style 0
calculate average values for 100 records in the shortest way? 5
Inconsistent formatting of section numbers 0
How to calculate difference between two date & time along with working hours and days 2
Show week number in Project Report 0

Top