Simple question =cell - number

[exceliz]

well it seems simple but i cannot think how to do it

all i want to do is
in cell m15:
formula =m14 / 6
but then next week
formula=m14 / 5

so each week i am dividing the cell by a number less each time

sound simple but its driving me mad

Thanks
Liz

 

[Toonies]

hi check this out

http://blogs.office.com/b/microsoft-excel/archive/2009/06/30/week-numbers-in-excel.aspx

it may help

 

[exceliz]

thanks, very useful with working with dates - think i may use this for something else

but what i need is a cell divided by 6,
then when the data is refreshed dividied by 5.
etc

there are no dates on display in my pivot.

Thanks