Hi,
I am sorry to Go on, please be patient... advise further with me:
Confirm the following: So I am correct to say that although I am considering
half year periods, the calculations are not entirely the same?
a) 1 year = 12 months so half year period is 6months - 1 day......wanted
result
b) 1 Year = 52 Weeks so half year period is 26 Weeks - 1 day
C) 1 Year = 365 days so half year period is 182.5 days - 1 day

Thanks in advance

PS: I am not even sure why I would be taking 1 day off the period....would
this be standard practice when working with financial time periods?




"Gary''s Student" wrote:

For example:

START 16-Nov-2006
1 week later 23-Nov-2006
2 weeks later 30-Nov-2006
3 weeks later 7-Dec-2006
4 weeks later 14-Dec-2006
5 weeks later 21-Dec-2006
6 weeks later 28-Dec-2006
7 weeks later 4-Jan-2007
8 weeks later 11-Jan-2007
9 weeks later 18-Jan-2007
10 weeks later 25-Jan-2007
11 weeks later 1-Feb-2007
12 weeks later 8-Feb-2007
13 weeks later 15-Feb-2007
14 weeks later 22-Feb-2007
15 weeks later 1-Mar-2007
16 weeks later 8-Mar-2007
17 weeks later 15-Mar-2007
18 weeks later 22-Mar-2007
19 weeks later 29-Mar-2007
20 weeks later 5-Apr-2007
21 weeks later 12-Apr-2007
22 weeks later 19-Apr-2007
23 weeks later 26-Apr-2007
24 weeks later 3-May-2007
25 weeks later 10-May-2007
26 weeks later 17-May-2007
less one day 16-May-2007


Each date is seven days (1 week) more than the previous date (except, of
course, the last entry)
--
Gary''s Student - gsnu200725


"Dermot" wrote:

Hi Gary
I have a further question relating to this topic.
I am trying to understand the relationship between working in periods of
Weeks and Periods of months....but can't determine how to get the same result
using the same start date.
For Example

If I want
6 months minus a day
Start Date: 16/05/2007 + 6 months - 1day
Result: 15/05/2007

Doing the same in Weeks
Using the formula given with the following data
Start Date: 16/11/06
N0 of Weeks: 26
Offset: -1
Result: 16/05/07
I expected to get the 15/5/2007 as the result.

I assume this may be because some months have 5 weeks / different number of
days.

Can you clarify what I am over looking here and how I could demonstrate it
in excel.
Thanks in advance








"Gary''s Student" wrote:

put the start date in A1, the number of weeks in B1 and the offset in C1
In D1 put:
=DATE(YEAR(A1),MONTH(A1),DAY(A1)+7*B1+C1)
and format as dd/mm/yy
--
Gary''s Student - gsnu200723