Extract year, month and day from a date in Excel
🚨 ALL INFORMATION IN DESCRIPTION (CLICK ON "MORE") 🚨
#TutoExcel #Excel #MSExcel
🔴 To access the Master Club Excel, go here: https://www.votreassistante.net/forma...
🙋 Join the Votre Assistante Facebook group to share tips and tricks around #Word, #Excel, #Access, #PowerPoint, #VBA, #Photoshop and #Illustrator software: / votreassistante
⚠️ To better view the video, I advise you to set the quality of the video to HD by clicking on the toothed wheel (↓ at the bottom right → of the video). ⚠️
📢 To be informed of the publication of the next articles, subscribe to the newsletter and receive the checklist to design a powerful dashboard on Excel: https://formations.votreassistante.ne...
🚨 Subscribe to the channel by clicking on Subscribe (just above ↑) then on the 🔔 next to not miss any video 😉
Tutorial made with Excel 2019
Video tutorial to learn how to extract year, month and day from a date in Excel using Year, Month, Day, Today and Text functions.
🔗 To access the text version of this tutorial, go to Votre Assistante: https://www.votreassistante.net/extra...
☑️ Useful links:
https://www.votreassistante.net/forma...
https://www.votreassistante.net/forma...
📖 Summary:
00:00 Introduction
00:29 Announcement
01:10 1. Extract the year from a date in Excel
02:07 2. Extract the month from a date in Excel - 2.1. Extract month from Excel date with numeric result
02:45 2.2. Extract month from Excel date with text result
03:16 3.Extracting the day from a date in Excel - 3.1. Extract day from Excel date with numeric result
03:42 3.2. Extract day from Excel date with text result
🚀 To go further, join the Excel Master Club and become an expert on Excel formulas: https://www.votreassistante.net/forma...
🚀 To go further, find out how to get started on Excel from scratch: https://www.votreassistante.net/forma...
🚀 To go further, discover the 7 steps to create pivot tables like a pro on Excel: https://www.votreassistante.net/forma...
🚀 To go further, discover the application Gérez vos devis et factures avec Excel (with or without stock): https://www.votreassistante.net/appli... or https://www.votreassistante.net/appli...