Learn Date and Time Functions in Excel in 1 Video | Excel Tips
Excel Tutorial
Learn more about excel - https://www.exceltutorial.net/videos/24/date-and-time-functions/
I am going to show you how to do some really cool date and time functions in excel.
Today we're going over a list of five date & time functions that'll make your life so much easier when it comes to data manipulation. These are some simple formulas that will help you work with dates, times, or even look at how many days have passed since a certain event occurred. There's no better way than learning from someone who has been doing this for years!
I'm going to show you how to use Excel's date and time functions - and what they do!
In this video, I'll show you how to enter a date or time into Excel. I'll also teach you about the different ways in which we can format dates and times in Excel, such as entering a date with no year or month specified.
Functions like NOW(), TODAY(), TIME() and DATE() can be really helpful when you need to get the current date or time in your spreadsheet. And if you want to know what day of the week it is, just use WEEKDAY().
Excel's date and time functions are all pretty straightforward. What makes them tricky is that they work with a bunch of different date formats including YYMMDD, MMDDYY, YMDDYY, DDMMYYYY, DYMADDYAD or even just the day of the week.
We'll also go over some tricks for formatting your dates so they look nice on a spreadsheet!
We will cover the following in this video;
What is a Date Function
How to use the Date function in Excel
What is a Time Function
How to use the Time function in Excel
When should I use which date or time function in Excel
Bonus tip - how to get the current day of week and month name using a formula
Table Of Content: 00:00 Introduction 01:14 YEAR, MONTH, DAY Function 03:47 DATE Function 05:29 TODAYS Function 06:24 NOW Function 06:54 TIME Function 09:11 Conclusion
============================================================
Date & Time Functions in Excel :- https://youtube.com/playlist?list=PLhvn6aQRdimUCev65UqAttGkVn_f5ZOfe
============================================================
Other Playlists:-
Cell References in Excel - https://youtube.com/playlist?list=PLhvn6aQRdimVC65nzr2BebSN9kPSdK6qH
Logical Functions in Excel :- https://youtube.com/playlist?list=PLhvn6aQRdimWBCKHNrLEqubXDMaHeINU1
Count and Sum Functions in Excel - https://youtube.com/playlist?list=PLhvn6aQRdimVHQA5zqrJ6XG6e5jP5hyQN
Learn Data Validation In Hindi: https://youtube.com/playlist?list=PLhvn6aQRdimXirM12gw1eijuiMYta-Oqf
Learn Excel Tutorials Online:- https://www.youtube.com/playlist?list=PLhvn6aQRdimWKL2jOmJxQBEBTeIzmx-zW
Excel Analysis Tutorial: https://youtube.com/playlist?list=PLhvn6aQRdimUhgO4q3gJWiz4QrbSVGmIz
25720533 Bytes