Calculating number of weeks between dates (start and end dates)

[Guest]

Two things I would like to do and I presume that Excel is the software to do
it:

1. Ability to calculate the number of weeks between two dates. For example
how many weeks betweeen April 2, 2007 and August 31, 2007.

2. Ability to calculate a date based on a number of weeks. For example, if
I want to calculate the end date of a course which begins on April 2, 2007
which needs to end 56 weeks later, what is the end date.

Can anyone help?

 

[Dave Peterson]

Dates are just numbers to excel.

So you can subtract the earlier from the later and divide by 7 and format the
results as General (excel likes to help and keep the format a date).

And you can add 56 weeks to a date in A1:

=a1+(56*7)
(format as a date)

Excel also has some date related functions (in the analysis toolpak in xl2003
and below).

You may want to look at:
=networkdays()
=workday()
=eomonth()

And one function that isn't documented (except for xl2k):
=datedif()

But Chip Pearson has some very nice notes:
http://www.cpearson.com/excel/datedif.htm