Excel Formula - Find the Week Number from any given Date

In this video, we use an Excel formula to return the week number of any given date. Just enter a date and the formula returns the week number of that date, from a specified start date.

Excel has a function called WEEKNUM. And although useful, this is limited to finding the week number of a date from the 1st January of that year.

The formula in this video tutorial though will enable you to specify a start date, and we can count how many weeks until another date.

You could even reverse the formula and get a week countdown until a due date or deadline.

Find more great free tutorials at;

*** Online Excel Courses ***

Connect with us!

[Wildbill]

Wow! You just showed me everything plus, cause i had been wanting to know how to print using the settings for those given cells,

Thanks, you are a genius

[RachelKing-qnil]

The most helpful video on this subject I have seen and the only one that actually worked the way I needed it too! Thank you so much!!!!

[fratsivasloglu]

This tip saved my day. I am genuinely grateful for that.

[aguerojg]

Excellent trick, Thank you very much Alan for your kindness in explaining it. You did all the steps calmly, it is wonderful to watch your videos. Keep up the awesome job!

[wayneedmondson]

Hi Alan.. good trick. For uneven date sequences, the divide by 7 procedure produces a number with trailing decimals. I see you just formatted to see only the integer portion. You could also wrap the formula with INT() to force only the integer value. Arguably not needed, as formatting does the trick. Thanks and Thumbs up!

[proudlyfitbygaurav]

Very cool, Very smart formula. This video has helped in a great way!

[PankajSingh-dcqp]

Superb... Great video... thanks a lot

[mazhylis]

1st time watching video in this channel, and im sorry but when he said gaga, I went gaga oh la la :D

[haimantichatterjee]

Hello, could you show us how to determine a specific duration for eg 16 weeks from a specific date ?

[DaXia]

For Swedish people, its =veckonr(x;21). Varsågod.

[VS-rhrq]

Great stuff..but would this formula need to covered by MOD function in cases where they is remainder from 7 day week division?

[SimmoSC]

Hi. Does this work when dates are spread across several years? I’m looking at planning dates - 03/04/2021 is Week 01, as is 02/04/2022, and so on

[AdA-fkyq]

Can you get Excel to fill in weekly dates down a column automatically?, from a random week in the year.

[Lheadjc]

I'm sorry but I do not speak english! But, nothing Google can't fix! (LOL). How to find out the epidemiological week of a date? I love your channel!

[KumarEshanK]

Great stuff, however what if i want the week 2 start on next Monday of that month ? Ex my companies fiscal year starts on 1st nov, let’s assume it starts on a Friday ., so i want nov 1 to 3, 3rd nov will be Sunday - to be shown aa wk- 1 and nov 4th since it’s a Monday and start of new week must show as wk 2

[LotfyKozman]

That's very fine, what if I want set my equation which reflects the week number of each month such as (w1, w2....) for Jan, then convert automatically to (w1. W2...w5) for Feb, and so on

[moekyawsann]

How can i try to set only Oct-18 month to return week number and ignore Nov-18 from this example ?

[creative_gujarati]

How to calculate week number if my year is starting on 1st April

[nauti]

Great video. learnt something new. I have been trying to do a table that weekly targets are set for the months. I can't get around it. Can you pls help me with that. Eg. Wee1, Week 2, Week 3 in one column and Targets in another column

[andres]

I'm looking for a way to get the Week Number and the year on the same cell. For example: 01/07/2019 = 02/2019.
Is that something you can help me with?