one formula that convert any given date to week no.of the year.

mykonen · #1 Oct 29, 2009, 12:14 AM

What are the formula in excel to convert any given date to the week of that date in that year.

Example: 29 October 2009 is Week 44.

TQ.

Khalil.

ebaines · Oct 29, 2009, 06:03 AM

Try this:

=WEEKNUM(DATE(2009,10,29),1)

If you get a #NAME? error that means you need to install the Analysis Toolpack Add-In into Excel.



At Ask Me Help Desk you can ask questions in any topic and have them answered for free by our experts. To ask questions or participate in answering them you must register for a free account. By registering you will be able to: Get free answers from experts in any of our 300+ topics. Accept money for answers that you provide. Communicate privately with other members (PM). See fewer ads. Sign Up!