Youtor
Excel EOMONTH DATE YEAR MONTH date functions by Chris Menard
>> YOUR LINK HERE: ___ http://youtube.com/watch?v=qLbl9sgg-tI
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!
#############################
