Difference in Weeks between 2 dates

G

Guest

Hi there

I am desperately trying to figure out the difference between 2 dates in
weeks. Could somebody help me out? I greatly appreciate your help.

Thanks
Susanne
 
G

Guest

Would this work for you ???

=(EndDate - StartDate) / 7

You could use the round, roundup, or rounddown functions to play with the
result.

Hope this helps.

Bill Horton
 
G

Guest

Look at WEEKNUM function.

You need 'Analysis Toolpak'

Tools=>Add-ins=>check 'Analysis Toolpak'
 

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

Formula to calculate the difference in weeks between two dates 3
If Statement 2
Calculate difference between current date & prior 3
Excel Average dates help 0
Create Calculation to return number of weeks and days 6
Average of difference between dates greater than zero 8
Calculating number of weeks between dates? 2
Between dates 2

Top