Week of the Year

[DJGLIPH]

Ok I need a formula to produce the week of the year based on todays date. (i.e. a week number 1-52)

My goal is to be able to produce a "shipped tons per week" number without updating the formula everytime I need the number

Thanks

 

[Oaktree]

Try the WEEKNUM function (requires the analysis toolpak add-in)

 

[DJGLIPH]

=WEEKNUM(TODAY(),1) WORKED FABULOUS!

THANKS A BUNCH