Hi Leo...it is great...tx a million...now if I could just understand the
formula!!! Is there a reference I could read to get a better grasp of just
how it works...tx again, your help was really appreciated. rgds john

"Leo Heuser" wrote:

"John48" skrev i en meddelelse
...
Hi again Leo...I was premature in thinking I needed additional formula for
the YTD, the PTD formulas work well in conjunction with the YTD formulas I
already have in place I think...but there may be a better way!! thanks
again
John

"John48" wrote:

Thanks Leo...I wasn't too clear in my initial posting....PTD is the 4
week
Period...and there are 13 Period is the year..hence YTD. Gets a little
more
complicated on the YTD. Each sheet is a period, there are 13 sheets and
on
each sheet is the PTD and the YTD with the YTD carrying foreward from P1
to
P13!!
Anyway..I sent you the sheet..hope it is ok...tx a million rgds John



Hi again John

I have just returned the workbook.
Please let me know, if it works.

Regards
Leo Heuser