Dave

I think Helen would need to add 28 days each time not 27.
Adding 27 will give the last day of the period, as opposed to the first
day of the subsequent period.

--
Regards

Roger Govier


"Dave F" wrote in message
...
To find the date that each period represents, start with the first day
of the
fiscal year, 4/1/2005

=(4/1/2005)+27 will give you the beginning of your second period, and
so on,
through the eight period, more or less. You may need to adjust some
of these
calculations, since as you say the 28-day period is an average.

Dave
--
Brevity is the soul of wit.


"Helen" wrote:

Hello,

I cannot solve this one: a client is dividing a whole year into 13
periods
(average of 28 days). The financial year starts on April 1, 2005 and
ends on
March 31, 2006. We need to know what date would period 8, for
example,
represent? If the column labels are Period 1, Period 2, etc., what
would the
middle of that period be in terms of a specific date?

I sincerely hope you can help me!

Thank you.

Helene