Fresh Excel Tips

Quick and Easy Excel Tips and Tutorials

How to Use the WEEKNUM function to determine the week number
Addicted To Cialis Medrol Packs Buying Viagra Over The Internet Bio Brite Sun Alarm Can Plavix Substitute For Coumadin Viagra And Affiliate Breast Augmentation Discussion Boards Natural Herb For Lasix Plavix And Inr Breast Enhancement Capsules Ultra Curves Estrogen Coral Calcium Supreme 240 Zelnorm Affects Birth Control Patti Labelle Clas Of The Choirs Benefit Of Coral Calcium Hgh Effects On Teens Buy Hgh Buy Hgh Buy Hgh Anoretic Cardura Medication Leukeran Pet Medication Levitra For Females Out Of Court Settlement For Viagra Prednisone Prescribing Lamictal Bipolar 1 Aleve Pregnancy Coumadin Anticoagulation Drug Interaction Cipro Zoloft And Sudafed Plavix And Aspirin Interactions Use Zovirax For Effective Herpes Treatment Medrol Dose Pack And Crohns Synthroid Hot Flashes Geodon Im Cialis Manufacturer Jewish Purim Cookies Squill And Lipitor Synthroid Destroys Thyroid Advil Or Motrin Atarax Prescribing Information Flonase For Kidney Stones Lotrisone Cr 30 Mg Cost Of Viagra In The Philippines Can I Take Prozac At Night Zoloft Cleft Palatte Benefit Of Coral Calcium 0a North Beach Pizza Soma San Francisco Viagra Over Counter Herb Valproic Depakote Hypothalmus Hoodia Tlc Lasix Veterinary Dose Of Tramadol Neurontin Use

To determine the week number of a particular date, you will need to load the Analysis ToolPak add-in. This is accessed by choosing Add-Ins… from the Tools menu in Excel 97, 2000  and 2003. In Excel 2007, select Excel Options from the Office menu then select Add-Ins in the left pane. Select Analysis ToolPak from the listbox then click Go and make sure that the Analysis ToolPak is selected.
By doing this, the WEEKNUM function will become available. This function returns a number that indicates where the week falls numerically within a year.
How to determine the week number
1.    In Column A, enter different dates as is necessary.
2.    Select cell B1 and type the following formula: =WEEKNUM(A2).
3.    Use the fill handle to copy the formula as needed.

You should now be set.

How to Use the WEEKNUM function to determine the week number
  1. How to Display Day of the Week in Excel using a Custom Format
  2. How to Use the PMT function to determine the payment of a loan
  3. Use the NETWORKDAYS function to determine number of workdays
  4. How to Use the SUMSQ function to determine the square sum
  5. Use the EOMONTH function to determine the last day of a month

Article Information

Category
Formula and Function Examples

Tags
,

Trackback URI

Comments RSS


Leave a Reply

← How to Use the SMALL function to compare prices in Excel
How to Use the SUBTOTAL function to count rows in filtered lists →