[FREE EXCEL COURSE] Lesson 15 - Date & Time Formulas in Excel

In this video of this online Excel Training, you will learn about the following DATE and TIME formulas:

-- DAY function
-- HOUR function
-- MINUTE function
-- DATE function
-- DATEVALUE function
-- TODAY function
-- NOW function
-- WEEKDAY function
-- NETWROKDAYS function
-- NETWORKDAYS.INTL function
-- WORKDAY function
-- WORKDAY.INTL function

This video is a part of my Free Online Excel Training where I show you how to use Excel from the basics and also cover a lot of advanced topics.



⚙️ Gear I Recommend:

Note: Some of these links here are affiliate links!

#Excel #ExcelTips #ExcelTutorial

[wayneedmondson]

Hi Sumit.. thanks for this complete and useful video on DATE and TIME functions. I especially like the tip for the .INTL functions using the "0101010" format to customize the days you want to be workdays "0" vs. non-workdays "1". Thanks again for sharing this video series for free. Thumbs up!

[JourneyJunction]

thank you so much for this by this a can do many things and gain knowledge

[iliesboukhatem]

a great tutorial, thank you so much !

[gheghe]

hello, first i want to thank you for your in dept exel course.
is it possible to make a timing format were you dont have to type the colon between hours and minutes? i have to type a lot of timings and was wondering if it is possible to type it in the format of 1412 i.o. 14:12 and exel changes it automaticly.
many thanks in advance

[abduljaleelashraf]

Hai Sumit great videos..How to sum up the data within a specified date range.. Eg; many entries pertaining to january2019..need your advise

[livelife]

how to find workbooks that used in these tutorials

[janakiyeluripati]

Hi,
when i type 12.00 AM in my excel sheet the input is takes as text and is aligned to the left. But in your video the input is aligned to the left. So what to do. I tried fomat cell using right click and changed it to a number but still it remained right aligned?

[bhargavisweety]

Hello Sumit. Thank you for your teaching Excel in simple way. I have a doubt. I didn't understand =Day(41699) How this number mean 01-March-2014. March is 3rd month in calendar and April is 4th right.
Can you please elaborate =Day(41699).

[bhargavisweety]

I didn't understand this 41699 logic. Can anybody please explain me

[rathnakishorev]

how does 41699 represent 1st march 2014

[jayasimha]

Hello everyone, can anyone explain that different serial number can converted into date format at once, where I have 20 lakh serial numbers?

[anupriyasrivastava]

When I use NETWORKDAYS formula to find out working days between the start date and end date i.e., 01/03/2014 and 09/06/2014 then my output is 176 and in video the output is 71 what should I do to correct my output????

[hemalathareddy]

date and time function are not properly working in 2007...version

[ellisiverdavid]

Hi Mr. Sumit! I'm trying to SUMIF using the month as a criterion.
In this instance, I'd like to add all sales in January.

Why can't I just calculate it using "=MONTH( *cell with date* )" directly in the SUMIF, then equate it to 1, since 1 denotes January anyway? Here's what I'm trying to fix:
=SUMIF( *dates in column A*, "MONTH(A1)=1", *sales in column B* )

Could you help me point out a rule that I violated or may have missed, please?

[khushiheda]

instead of =DAY(TODAY())+13 if we write =DAY(TODAY()+13)
we wont have to be cautious of the value of day exceeding 31!!