How about another cell with nothing but the number. Or, weeknum*3 idea. Or,
edit/replace

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Donnas3944" wrote in message
...
I have a spreadsheet that I update weekly with several formula's in it and
contains several weeks of information. Each week when I go in and update
it
he final step is to change the number of weeks I am dividing by. Example
this
week was 28, next Friday I will need to divid by 29. This has to be
changed
in 3 locations on the SS. Is there a way I can add a fromula that I can
change that will change this number in all 3 locaitons and only have to
change it once.