How to Use Day Function in Excel

In this Excel Function Explained video series, I will explain, how to use DAY function in excel. In this function we extract Days either from serial number or from the date provided. Suppose you have a date in cell A1 with a date 31/7/2020 now if you use the Day function it will return 31. This function works either with date or serial number.

Now what is serial number in date in excel?
Excel starts counting date from 1900 and it counts date based on serial number. Let’s say we have 1/1/1900. This is the first date according to excel and it has a serial number 1. From that day excel add 1 to every passed date. Now if you write 7/1/1900 that will have a serial number 7. Because it is the seventh day so the serial number 2000 means 2000 day from 1/1/1900. This is how serial number in date works in excel.

Let’s learn how to use DAY formula in excel.

The Function looks like this =Day (Serial Number)
This function has only one argument or parameter.

1. Serial Number: In this parameter we need to write date or serial number from which excel will extract Day.  

This is how we use DAY in excel. Remember, using DAY function in excel you actually tell excel formula to format and extract Day from a serial number or date inside a data range you specify.

#Excel #Function #Day

Thanks for watching.
-------------------------------------------------------------------------------------------------------------
Support the channel with as low as $5
Patreon: excel10tutorial
-------------------------------------------------------------------------------------------------------------
Please subscribe to #excel10tutorial
https://goo.gl/uL8fqQ

Here goes the most recent video of the channel:
https://bit.ly/2UngIwS

Playlists:
Advance Excel Tutorial: https://goo.gl/ExYy7v
Excel Tutorial for Beginners: https://goo.gl/UDrDcA
Excel Case: https://goo.gl/xiP3tv
Combine Workbook & Worksheets: https://bit.ly/2Tpf7DB
All About Comments in Excel: https://bit.ly/excelcomments
Excel VBA Programming Course: http://bit.ly/excelvbacourse

Social media:
Facebook: Facebook: excel10tutorial
Twitter: Twitter: excel10tutorial
Blogger: https://excel10tutorial.blogspot.com
Tumblr: Tumblr: excel10tutorial
Instagram: Instagram: excel_10_tutorial
Hubpages: https://hubpages.com/@excel10tutorial
Quora: https://bit.ly/3bxB8JG

• #education
• #excel_10_tutorial
• #excel_tutorial
• #excel
• #tutorial
• #microsoft_excel
• #excel_2019
• #excel_tricks
• #excel_tips
• #e10t
• #excel_function_explained
• #excel_function
• #excel_formula
• #excel_day_function
• #excel_day_formula
• #excel_formulas_and_functions
• #how_to_use_day_function_in_excel
• #what_is_serial_number_in_date_in_excel
• #serial_number_in_date
• #learn_how_to_use_day_formula_in_excel
• #excel_formula_to_format_and_extract_day_from_a_serial_number