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

[cindybrandner]

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

[rosavasquez]

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

[chuiya]

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

[cloudwatcher]

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?

[graykahel]

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

[Maskulada]

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

[truewiking]

Really well explained, Thank you very much

[tracybelley]

The woman in my course videos is confusing and most of the other Youtube vids talk very fast. Thank you for making this less frustrating for me.

[ilyaszaw]

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

[AbcXyz-kcmj]

My workday formula returns as 4457, what can i do to fix this?

[patrickwoo-ching]

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!

[resamitchell]

I need help for project im working on. Thus is confusing

[Chris-picj]

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.

[Dannyx]

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

[northstardaonuea]

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

[VIATEXAS]

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

[adilnaeem]

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

[theinacircleoftheancientpu]

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.