Date and Time Functions in Microsoft Excel - For Beginners
In this video, I will show you how to use date and time functions in Microsoft Excel. With these functions, you can create formulas that can do even more.
0:00 Introduction
1:32 The TODAY() Function
2:24 Create a formula with date functions in Excel
4:07 The NOW() Function
6:32 The TIME Function
8:08 The WORKDAY Function in Microsoft Excel
9:25 The DATEDIF Function
Download practice file: leveragingdigitalinc-my.share...
More Excel Function Tutorials: • Formulas and Function ...
Пікірлер: 36
Thank you so much for your tutorials- they are incredibly helpful to someone who is new to MS Excel.
@TeachersTech
2 жыл бұрын
You are very welcome!
Thank you so much for making this task easy. Finally I understand hahaha so clear and easy to follow along. Thank you
thank u very much. i use to be completely blank in excel but with all ur tutorials i am very goo at it and u hv made it really easy
Very detailed tutorial. Thank you
Really well explained, Thank you very much
This is useful formula for me. Thank you, sir.
Excellent tutorial, thanks sir
Thank you so much. I'm trying to brush up on excel... last time I used it was over 10yrs ago.
Thank you for this video. This is very informative and useful. ☺️
@TeachersTech
Жыл бұрын
Glad it was helpful!
thank you sir.
شكرا معلم
The woman in my course videos is confusing and most of the other KZread vids talk very fast. Thank you for making this less frustrating for me.
Excellent
I would love it if you could show how to set up a recipe keeper that helps with meal planning and a grocery list. Is that possible?
Thank you
@TeachersTech
2 жыл бұрын
You're welcome
Thanks
Can I set a date to change color when it's passed? Like vehicle registration date. If it passes it's a different color so I can easily see that one needs attention.
@RoyaltonDrummer922
10 ай бұрын
Should be able to do so with conditional formatting
Still couldn't figure it out. I'm trying to calculate the 'age' of the person? I tried following the example in this tutorial but had a hard time coming up with a formula. Please help!
Whenever i have to use quotation marks in a formula it doesnt work for me. Why?
When am Inputting date after about 10 columns it automatically changes to small format and shit to the right side how do I fix it
Using =NOW() , how do I add hours/minutes to that, to get a completion time later in the day? =NOW() + a cell ?
@TeachersTech
2 жыл бұрын
Yes, that’s correct. Try using the TIME function to add specific hour, minutes, seconds. Adding just a number will add days to it.
Thank you🙏
@TeachersTech
2 жыл бұрын
Welcome!
I swear I read "grace period days" as grace's period days. 😂 Would be nice if you showed how to put future dates that update too.
Hi teacher Honstly the vlesson was wonderful. However, the translation covered most of the explanation steps you made. Like , I personally did not recognize where you clicked in the menue bar until to follow you to the end of the lesson. I got lost unfortunately 😢😢
Birthday calculation formula is wrong
FIRST
@cappyjones
2 жыл бұрын
Your parents are still disappointed in you. 😁
@Incognito-zh9fd
2 жыл бұрын
@@cappyjones ok?????
Birthday calculation formula is wrong