My Digital Quill | Excel Formulas and Functions #29 | EOMONTH Function in Excel | Excel tips and tricks | Excel #shorts
EOMONTH Function is date function in Excel that returns the last day of a month from a given date. This function takes two arguments: one as the date and another as an integer for the number of months preceding or succeeding your reference date. The output is in date format.
This example explains on how to use EOMONTH function for a simple problem whereby a array of dates are given in one column and the number of months exceeding (positive integers) or preceding (negative integers) the date. The EOMONTH( ) function in the corresponding column returns the end of the month for the reference date as dictated by the number of months specified in the second.
Credits:
Thumbnail Photo by Justin Morgan on Unsplash
Exceljet
https://exceljet.net/excel-functions/...
Please check out more Excel tips and tricks from the playlist link down below:
• Excel Tips and Tricks
Check this playlist for Excel formulas and functions:
• Excel Formulas and Functions Series
Free Excel Course available on formatting techniques in here:
• Excel Formatting Techniques
🔔 Subscribe for free Office Tutorials at My Digital Quill:
/ @mydigitalquill8945
#eomonthfunction #eomonthfunctioninexcel #exceldatefunctions #Excelformulasandfunctions #Exceltipsand tricks #Excelshorts
#MyDigitalQuill
Watch video EOMONTH Function in Excel | online, duration hours minute second in high quality that is uploaded to the channel My Digital Quill 19 June 2022. Share the link to the video on social media so that your subscribers and friends will also watch this video. This video clip has been viewed 50 times and liked it 2 visitors.