Excel: EOMONTH, DATE, YEAR, MONTH, date functions by Chris Menard

There are over 450 functions in Excel. When it comes to dates, there are five functions you must know. EOMONTH, DATE, YEAR, MONTH, and DAY are among them.

In this video, I analyze getting paid twice a month or semi-monthly. To calculate the last day of the monthly, I use the EOMPNTH function. It is nested inside the DATE function. Here is a breakdown of the functions:

YEAR function - gives you a year. If an invoice date is 7/14/2021, the year function will pull out the year and return 2021.
MONTH function - gives you a month. If an invoice date is 7/14/2021, the month function will pull out the month and return 7.
DAY function - gives you a day. If an invoice date is 7/14/2021, the day function will pull out the day and return 14.
EOMONTH function - will find the end of the month from a date. If the date is 7/14/2020, the end of the month function will return 7/31/2020. If the date is 4/12/2021, the end of the month will return 4/30/2021. The EOMONTH function has two arguments.
DATE function - has three arguments. Year, Month, and day.

#msexcel #chrismenardtraining #microsoftexcel #microsoftcreator

Chris Menard's website: https://chrismenardtraining.com

Chris Menard is a trainer for the Georgia Society of CPAs (GSCPA) and the University of Georgia Terry College of Business. He is a member of Microsoft's Creator Team and works full-time as a Training Specialist for a global law firm in Atlanta, Georgia.

And make sure you subscribe to my channel!

-- EQUIPMENT USED ---------------------------------
○ My camera – https://amzn.to/3vdgF5E
○ Microphone - https://amzn.to/3gphDXh
○ Camera tripod – https://amzn.to/3veN6Rg
○ Studio lights - https://amzn.to/3vaxyy5
○ Dual monitor mount stand - https://amzn.to/3vbZSjJ
○ Web camera – https://amzn.to/2Tg75Sn
○ Shock mount - https://amzn.to/3g96FGj
○ Boom Arm - https://amzn.to/3g8cNi6

-- SOFTWARE USED ---------------------------------
○ Screen recording – Camtasia – https://chrismenardtraining.com/camtasia
○ Screenshots – Snagit – https://chrismenardtraining.com/snagit
○ YouTube keyword search – TubeBuddy – https://www.tubebuddy.com/chrismenard

DISCLAIMER: Links included in this description might be affiliate links. If you purchase a product or service with the links I provide, I may receive a small commission. There is no additional charge to you! Thank you for supporting my channel, so I can continue to provide you with free content each week!

Видео Excel: EOMONTH, DATE, YEAR, MONTH, date functions by Chris Menard канала Chris Menard