Date Formulas in Excel | Extract the year, weekday, Month and week number from any date in Excel.

Date formulas in Microsoft Excel can help you extract the necessary information from any data set in order to drill the data down by the Year, the Month, the week number, the day of the week and much more. In this video I'll go over all of them:
• How to get "2020" from 2/10/2020
• How to get "February" from 2/10/2020
• How to get the week number "7" from 2/10/2020
• How to get "Tuesday" from 2/10/2020

Here are some more videos you might like:

Thanks for watching. Don't forget to subscribe, hit the bell notification, share the video and comment on what date formula you need to use after watching the video!

[gretchenesely]

I am breaking down sales by year and by weekend or weekday. Your video gave me a head start on my project. Thank you!!!!

[lizbuderus]

super helpful! All these years I've been converting years and months by doing a Text to Columns split. This is easier!

[pausterizado]

Thanks dude, I've been searching for this for an hour! you saved me

[ridingnorthernlights]

Such simple formulas but with massive impact! I'll be using all of these when working with dates that I need to strip apart. Thank you so much for putting such well explained, clear and SHORT video to explain these little beauties. Liked and subscribed....it's the least any one of us can do to show that we appreciate your time and dedication! :-)

[mustangfan]

Thank you, I always appreciate the time someone has taken to share their knowledge. Even after years of using Excel, there is always a new requirement, and frankly using practical videos like yours is preferable to running through help on Microsoft.

[mrsmelaniecook]

Thank you - I used the week number function. This was clear and helpful. So you know, I am looking for a new job, and this is going to help. Your impact is far-reaching! Hope this helps to support you.

[benjaminbruce]

Thanks so much, this was exactly what I was looking for. That is rare in youtube!

[alisalis]

Another great video - I used the text month formula. Thxs

[harunarslan]

Thank you. I like your style. Good luck with your channel

[jxf]

Thank you for sharing. It is useful and yet short and sweet. Thumbs up

[adebomiblessing]

Great....
Solved my challenge..
Thanks ❤

[Hellmuthj]

As a new entrepreneur trying to write my first budget your videos are crazy helpful! Thanks a lot!

[thesparklingearings]

Understood very well...
Thanks and regards from
Tamilnadu India..

[venkatrap]

you are awesome brother excellent work

[ericrogers]

Hi, Thanks for the video, a GREAT help. What format do you need in the columns, General? Text ? also any chance of a video on Years old from the date column. Many thanks, regards

[sinhavon]

This was very helpful. Thanks for sharing your knowledge 🤗

[ArthurCapers]

All of then formulas, but a lot can be force by using the date field in a pivot table

[davehedge]

I will use the week num function but have a question. Is there a function for calculating the week number other than Jan. 1? I'd like to start my business calendar year on 11/1 instead. thanks.

[redhaakhund]

Excellent video. I have a list of names which i need to extract only names who worked on Friday and Saturday only. Can you please advise me how to do this? thanks a lot

[secretaryphone]

I'm unsure why (so frustrating!) but the =YEAR formula does not separate out the year in my worksheet.
...may need to take beginning excel...