O
o77i3
Hi! is there a way of automating the number of weeks based on the now()
date? (i.e. 52 weeks/year)
Thanks!
date? (i.e. 52 weeks/year)
Thanks!
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
F
Frank Kabel
Hi
do you mean
=WEEKNUM(TODAY())
do you mean
=WEEKNUM(TODAY())
O
o77i3
I'm sorry but i've tried it and it did not work
F
Frank Kabel
Hi
you need to install the Analysis Toolpak Addin for this ('Tools - addins')
you need to install the Analysis Toolpak Addin for this ('Tools - addins')
O
o77i3
It worked! thanks! ...........if it is, i'm coming up with 51.....is it
correct?
correct?
H
Harald Staff
That depends on which definition of "week 1" you are using.
HTH. Best wishes Harald
HTH. Best wishes Harald
F