Difference in Weeks between 2 dates

G

Grd

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
 
W

William Horton

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
 
T

Toppers

Look at WEEKNUM function.

You need 'Analysis Toolpak'

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