Formula ?

[zone709]

Hi,

I use this formula =3*B6+E6 Can I have this change every Monday? like 4*B6+E6 then the Monday after that 5*B6+E6. I am going up 1 * every week.

Thanks for any help

 

[Joe4]

You can make use of the WEEKNUM function.

So, it you used this:
=WEEKNUM(TODAY())
it would return 38. If you want today to be 3, then just subtract 35.

So your dynamic formula would be:

[COLOR=#333333]=(WEEKNUM(TODAY())-35)*B6+E6[/COLOR]

 

[Eric W]

It's worth noting that WEEKNUM will reset at the end of the year to 1 again. If you want your series to continue from December to January, you can use this:

=INT((TODAY()-A1+7)/7)*B6+E6

Put the date you want to start at, where the constant will be 1, in A1.

 

[zone709]

ok got it. Yes it would continue threw the new year. Thanks for the help guys.