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?

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

Gerald Lemay wrote:
>
> 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