View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
kimdnw kimdnw is offline
external usenet poster
 
Posts: 8
Default automaticly increment number by elapsed time

You are correct that I am looking for the calendar year week count in the
expectation block. I copied this formula and am receiving "#NAME", and the
internal paranthesis are showing green. Does this mean I need to insert more
data?

Kim

"GSnyder" wrote:

I'm thinking you can get the expectation by using =Weeknum(now()) as long as
you're OK with it resetting each year and you start with the calendar year.

Would that work, or do you need something a little more sophisticated?