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

  • @cindybrandner3063
    @cindybrandner30632 жыл бұрын

    Thank you so much for your tutorials- they are incredibly helpful to someone who is new to MS Excel.

  • @TeachersTech

    @TeachersTech

    2 жыл бұрын

    You are very welcome!

  • @Maskulada563
    @Maskulada5632 жыл бұрын

    Thank you so much for making this task easy. Finally I understand hahaha so clear and easy to follow along. Thank you

  • @chuiya7019
    @chuiya70192 жыл бұрын

    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

  • @davidadeleye1113
    @davidadeleye11132 жыл бұрын

    Very detailed tutorial. Thank you

  • @truewiking
    @truewiking2 жыл бұрын

    Really well explained, Thank you very much

  • @ilyaszaw7459
    @ilyaszaw74592 жыл бұрын

    This is useful formula for me. Thank you, sir.

  • @simoiyahector-morales3781
    @simoiyahector-morales37812 жыл бұрын

    Excellent tutorial, thanks sir

  • @rosavasquez828
    @rosavasquez828 Жыл бұрын

    Thank you so much. I'm trying to brush up on excel... last time I used it was over 10yrs ago.

  • @graykahel8318
    @graykahel8318 Жыл бұрын

    Thank you for this video. This is very informative and useful. ☺️

  • @TeachersTech

    @TeachersTech

    Жыл бұрын

    Glad it was helpful!

  • @hassanarjmandnia
    @hassanarjmandnia2 жыл бұрын

    thank you sir.

  • @amaljaberi266
    @amaljaberi2662 жыл бұрын

    شكرا معلم

  • @tracybelley2211
    @tracybelley2211 Жыл бұрын

    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.

  • @wandabrowne8313
    @wandabrowne83132 жыл бұрын

    Excellent

  • @cloudwatcher4172
    @cloudwatcher417210 ай бұрын

    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?

  • @synobia104
    @synobia1042 жыл бұрын

    Thank you

  • @TeachersTech

    @TeachersTech

    2 жыл бұрын

    You're welcome

  • @thewarlordscalling6537
    @thewarlordscalling6537 Жыл бұрын

    Thanks

  • @Chris-pi1cj
    @Chris-pi1cj2 жыл бұрын

    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

    @RoyaltonDrummer922

    10 ай бұрын

    Should be able to do so with conditional formatting

  • @patrickwoo-ching792
    @patrickwoo-ching7922 жыл бұрын

    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!

  • @northstardaonuea
    @northstardaonuea Жыл бұрын

    Whenever i have to use quotation marks in a formula it doesnt work for me. Why?

  • @Dannyx40
    @Dannyx40 Жыл бұрын

    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

  • @VIATEXAS
    @VIATEXAS2 жыл бұрын

    Using =NOW() , how do I add hours/minutes to that, to get a completion time later in the day? =NOW() + a cell ?

  • @TeachersTech

    @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.

  • @haletahmasbipoor5522
    @haletahmasbipoor55222 жыл бұрын

    Thank you🙏

  • @TeachersTech

    @TeachersTech

    2 жыл бұрын

    Welcome!

  • @theinacircleoftheancientpu492
    @theinacircleoftheancientpu492 Жыл бұрын

    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.

  • @adilnaeem7441
    @adilnaeem74412 жыл бұрын

    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 😢😢

  • @mohsinshahab3090
    @mohsinshahab3090 Жыл бұрын

    Birthday calculation formula is wrong

  • @Incognito-zh9fd
    @Incognito-zh9fd2 жыл бұрын

    FIRST

  • @cappyjones

    @cappyjones

    2 жыл бұрын

    Your parents are still disappointed in you. 😁

  • @Incognito-zh9fd

    @Incognito-zh9fd

    2 жыл бұрын

    @@cappyjones ok?????

  • @mohsinshahab3090
    @mohsinshahab3090 Жыл бұрын

    Birthday calculation formula is wrong