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

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Gerald Lemay - 28 Mar 2007 02:08 GMT

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?

Reply to this Message

Dave Peterson - 28 Mar 2007 13:13 GMT

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

> Two things I would like to do and I presume that Excel is the software to do
> it:
[quoted text clipped - 7 lines]
>
> Can anyone help?

Signature

Dave Peterson

Reply to this Message