Difference in Weeks between 2 dates
 

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

Difference in Weeks between 2 dates
 

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

"Grd" wrote:

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

Difference in Weeks between 2 dates
 

Look at WEEKNUM function.

You need 'Analysis Toolpak'

Tools=Add-ins=check 'Analysis Toolpak'

"Grd" wrote:

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