Excel - schedule with week numbers

Here is a small project I’ve done for my wife. She needed a schedule for project management, she uses it for a presentation, and it has to be formatted like that : week numbers like W52, with the corresponding dates from Monday to Friday beneath it.

Be in touch with me if you’d like me to solve some excel problem for you.

[znlnkgl]

For months I have been adding these manually until I found your tuitition on this. You have just made me a clever IT formula gal, ty so much!😍

[ik]

oh my god i'm looking for this literally the whole night!!! Thank you thank you thank you!

[ernesttostado]

Friendly challenge (because I will be having to deal with this at the end of the year):

Suppose you have a weekly yield report based off of work week numbers. Our report is based off of 13-weeks to show a rolling quarter.

With December rolling into January the work week counts would be from 50, 51, 52, to 1, 2, 3. What method(s) exist to make an automated/ semi-automated report without having to manually select or highlight the applicable data sets for the first 13 weeks of a new year without error or having the excel think you're asking for work week 1, 2024 when you will actually need work week 1, 2025??

thank you in advance!

[itsme]

great video, I subscribed!
here's a question; is there a formula that will return automatically that w41 is Oct etc..?

[madjayax]

0:29. Can you help me. I got problem on W44. The formula result is 28-32 instead of 28-1.

[ViralVideoToday]

This is a great tutorial.

But, what if I want the 29/08/2022 - 02/09/2022 (Weekdays Only) to be the Week 01?

I wanted to have this because I'm gonna use it for the School. Our School Year started on 29/08/2022.

[krvav]

MAn this video made me look like enstein in front of my cowerkers

[satishraj]

I want the dates based on the Week number we will enter. Is there any formula?

[lorettatafuro]

I have a question/ challenge for you on a budget that’s in excel and I’m not fluent on. I’m new to excel and do basic functions.

[palexxl]

What if you need to bring infos based on those weeks. Weeknum will not be enough cause it s not an array formula. If you want to automate your wife work based on another sheet from wich you will extract infos here you need something else like building an uniq key for the match. What if you can t just simply put 30 3 under December umbrela and you have to split this 30 31 on december, 1 3 jan, it s good but not complete. Thank you.