Dear DaveS,

Thank you both; this was exactly what I was looking for!

Helen

"Dave Peterson" wrote:

And you may want to use:

=date(2005,4,1)+27

Else you'll see that 4/1/2005 is treated as 4 divided by 1 divided by 2005--not
the date that it looks like.

Dave F wrote:

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

--

Dave Peterson