www.myonlinetraininghub.com
Open in
urlscan Pro
192.124.249.160
Public Scan
Submitted URL: https://clicks.aweber.com/y/ct/?l=8Pshy&m=iJfwKjAst9VR.Zj&b=99kON4FOzwXFMRLq5Qi8Zw
Effective URL: https://www.myonlinetraininghub.com/excel-eomonth-function
Submission: On May 31 via manual from GB — Scanned from GB
Effective URL: https://www.myonlinetraininghub.com/excel-eomonth-function
Submission: On May 31 via manual from GB — Scanned from GB
Form analysis
6 forms found in the DOMGET https://www.myonlinetraininghub.com/
<form class="search-form" method="get" action="https://www.myonlinetraininghub.com/" role="search"><label class="search-form-label screen-reader-text" for="searchform-1">Search site</label><input class="search-form-input" type="search" name="s"
id="searchform-1" placeholder="Search..." required=""><button class="search-form-submit button-secondary" type="submit" value="Search"><span class="screen-reader-text">Submit search</span><svg xmlns="http://www.w3.org/2000/svg"
viewBox="0 0 512 512" class="search-form-submit-icon" width="24" height="24"><!-- Font Awesome Pro 5.15.3 by @fontawesome - https://fontawesome.com License - https://fontawesome.com/license (Commercial License) -->
<path
d="M508.5 468.9L387.1 347.5c-2.3-2.3-5.3-3.5-8.5-3.5h-13.2c31.5-36.5 50.6-84 50.6-136C416 93.1 322.9 0 208 0S0 93.1 0 208s93.1 208 208 208c52 0 99.5-19.1 136-50.6v13.2c0 3.2 1.3 6.2 3.5 8.5l121.4 121.4c4.7 4.7 12.3 4.7 17 0l22.6-22.6c4.7-4.7 4.7-12.3 0-17zM208 368c-88.4 0-160-71.6-160-160S119.6 48 208 48s160 71.6 160 160-71.6 160-160 160z">
</path>
</svg></button>
<meta content="https://www.myonlinetraininghub.com/?s={s}">
</form>
POST https://www.myonlinetraininghub.com/wp-comments-post.php
<form action="https://www.myonlinetraininghub.com/wp-comments-post.php" method="post" id="commentform" class="comment-form" novalidate="">
<p class="comment-notes"><span id="email-notes">Your email address will not be published.</span> <span class="required-field-message">Required fields are marked <span class="required">*</span></span></p>
<p class="comment-form-comment"><label for="comment">Comment <span class="required">*</span></label> <textarea id="comment" name="comment" cols="45" rows="8" maxlength="65525" required=""></textarea></p>
<p class="comment-form-author"><label for="author">Name <span class="required">*</span></label> <input id="author" name="author" type="text" value="" size="30" maxlength="245" autocomplete="name" required=""></p>
<p class="comment-form-email"><label for="email">Email <span class="required">*</span></label> <input id="email" name="email" type="email" value="" size="30" maxlength="100" aria-describedby="email-notes" autocomplete="email" required=""></p>
<p class="comment-form-url"><label for="url">Website</label> <input id="url" name="url" type="url" value="" size="30" maxlength="200" autocomplete="url"></p>
<p class="comment-form-cookies-consent"><input id="wp-comment-cookies-consent" name="wp-comment-cookies-consent" type="checkbox" value="yes"> <label for="wp-comment-cookies-consent">Save my name, email, and website in this browser for the next time
I comment.</label></p>
<p class="form-submit"><input name="submit" type="submit" id="submit" class="submit" value="Post Comment"> <input type="hidden" name="comment_post_ID" value="9957" id="comment_post_ID">
<input type="hidden" name="comment_parent" id="comment_parent" value="0">
</p>
<p class="comment-form-ant-spm" style="clear: both; display: none;">
<strong>Current ye@r</strong> <span class="required">*</span>
<input type="hidden" name="ant-spm-a" id="ant-spm-a" value="2023">
<input type="text" name="ant-spm-q" id="ant-spm-q" size="30" value="2.2">
</p>
<p class="comment-form-ant-spm-2" style="display:none;">
<strong>Leave this field empty</strong>
<input type="text" name="ant-spm-e-email-url" id="ant-spm-e-email-url" size="30" value="">
</p>
</form>
#
<form role="search" action="#" autocomplete="off" aria-label="Search form">
<input type="search" class="orig" placeholder="Search 500+ posts here..." name="phrase" value="" aria-label="Search input" autocomplete="off">
<input type="text" class="autocomplete" name="phrase" value="" aria-label="Search autocomplete input" aria-hidden="true" tabindex="-1" autocomplete="off" disabled="">
</form>
Name: options —
<form name="options" class="asp-fss-flex" aria-label="Search settings form" autocomplete="off">
<input type="hidden" name="current_page_id" value="9957">
<input type="hidden" name="woo_currency" value="USD">
<input type="hidden" name="qtranslate_lang" value="0">
<input type="hidden" name="filters_changed" value="0">
<input type="hidden" name="filters_initial" value="1">
<div style="clear:both;"></div>
</form>
POST https://www.aweber.com/scripts/addlead.pl
<form method="post" class="af-form-wrapper" accept-charset="UTF-8" action="https://www.aweber.com/scripts/addlead.pl">
<div style="display: none;">
<input type="hidden" name="meta_web_form_id" value="973982977">
<input type="hidden" name="meta_split_id" value="">
<input type="hidden" name="listname" value="awlist6409154">
<input type="hidden" name="redirect" value="https://www.myonlinetraininghub.com/excel-eomonth-function" id="redirect_47d86a87edd9d84a8f498e412d822197">
<input type="hidden" name="meta_adtracking" value="Sidebar_Signup">
<input type="hidden" name="meta_message" value="1">
<input type="hidden" name="meta_required" value="name,email">
<input type="hidden" name="meta_tooltip" value="">
</div>
<div id="af-form-973982977" class="af-form" style="background:#bce9ff;padding:15px;margin-top:55px;background-image: url(https://d13ot9o61jdzpp.cloudfront.net/images/arrow-blocks.png);
border: 1px solid #000;"><i style="margin: -35px auto;position: absolute;font-size: xx-large;color: #000;" class="fa fa-envelope" aria-hidden="true"></i>
<div id="af-header-973982977" class="af-header" style="margin-bottom:10px;padding:5px;">
<div class="bodyText">
<h4 style="color:#000;">Subscribe to Our Newsletter</h4>
</div>
</div>
<div id="af-body-973982977" class="af-body af-standards">
<div class="af-element">
<div class="bodyText">
<p style="margin:5px;color:#000;">Receive weekly tutorials on Excel, Power Query, Power Pivot, Power BI and More.</p>
</div>
<div class="af-clear"></div>
</div>
<div class="af-element">
<label style="color:#000;" class="previewLabel" for="awf_field-115275050">Name: </label>
<div class="af-textWrap">
<input id="awf_field-115275050" type="text" name="name" class="text" value="" onfocus=" if (this.value == '') { this.value = ''; }" onblur="if (this.value == '') { this.value='';} " tabindex="500">
</div>
<div class="af-clear"></div>
</div>
<div class="af-element">
<label style="color:#000;" class="previewLabel" for="awf_field-115275051">Email: </label>
<div class="af-textWrap"><input class="text" id="awf_field-115275051" type="text" name="email" value="" tabindex="501" onfocus=" if (this.value == '') { this.value = ''; }" onblur="if (this.value == '') { this.value='';} ">
</div>
<div class="af-clear"></div>
</div>
<div class="af-element buttonContainer" style="margin:10px auto;">
<center><input name="submit" class="submit" type="submit" value="Submit" tabindex="502"></center>
<div class="af-clear"></div>
</div>
<div class="af-element privacyPolicy" style="text-align: center;color:#000;">
<p>We respect your <a style="color:#000;text-decoration:underline;" title="Privacy Policy" href="https://www.aweber.com/permission.htm" target="_blank" rel="nofollow noopener">email privacy</a></p>
<div class="af-clear"></div>
</div>
<div class="af-element tag" style="display:none;"><input id="awf_tag-115275054" type="hidden" name="tag_115275054" value="newsletter"></div>
</div>
</div>
<div style="display: none;"><img src="https://forms.aweber.com/form/displays.htm?id=nOzMnBxMnOzs" alt=""></div>
</form>
POST #
<form action="#" method="post" novalidate="novalidate" autocomplete="new-password">
<div class="tve_lead_generated_inputs_container tve_clearfix tve_empty_dropzone">
<div class="tve_lg_input_container tve_lg_input" data-css="tve-u-11644b189fa4afe">
<input type="email" data-field="email" data-required="1" data-validation="email" name="email" placeholder="Type Your Email Here" data-placeholder="Type Your Email Here" class="">
</div>
<div class="tve_lg_input_container tve_submit_container tve_lg_submit" data-css="tve-u-12644b189fa4aff">
<button type="submit" class="" style=""><span class=""><strong>Download My eBook</strong></span></button>
</div>
</div>
<input id="_submit_option" type="hidden" name="_submit_option" value="redirect"><input id="_back_url" type="hidden" name="_back_url" value="https://www.myonlinetraininghub.com/exit-thank-you"><input id="_autofill" type="hidden" name="_autofill"
value=""><input id="_sendParams" type="hidden" name="_sendParams" value=""><input id="_api_custom_fields" type="hidden" name="_api_custom_fields"
value="YToxMDp7aTowO2E6Mjp7czoyOiJpZCI7czo0OiJuYW1lIjtzOjExOiJwbGFjZWhvbGRlciI7czo0OiJOYW1lIjt9aToxO2E6Mjp7czoyOiJpZCI7czo1OiJwaG9uZSI7czoxMToicGxhY2Vob2xkZXIiO3M6NToiUGhvbmUiO31pOjI7YToyOntzOjI6ImlkIjtzOjEyOiJtYXBwaW5nX3RleHQiO3M6MTE6InBsYWNlaG9sZGVyIjtzOjQ6IlRleHQiO31pOjM7YToyOntzOjI6ImlkIjtzOjExOiJtYXBwaW5nX3VybCI7czoxMToicGxhY2Vob2xkZXIiO3M6MzoiVVJMIjt9aTo0O2E6Mjp7czoyOiJpZCI7czoxMzoibWFwcGluZ19yYWRpbyI7czoxMToicGxhY2Vob2xkZXIiO3M6NToiUmFkaW8iO31pOjU7YToyOntzOjI6ImlkIjtzOjE0OiJtYXBwaW5nX3NlbGVjdCI7czoxMToicGxhY2Vob2xkZXIiO3M6ODoiRHJvcGRvd24iO31pOjY7YToyOntzOjI6ImlkIjtzOjE2OiJtYXBwaW5nX2NoZWNrYm94IjtzOjExOiJwbGFjZWhvbGRlciI7czo4OiJDaGVja2JveCI7fWk6NzthOjI6e3M6MjoiaWQiO3M6MTY6Im1hcHBpbmdfdGV4dGFyZWEiO3M6MTE6InBsYWNlaG9sZGVyIjtzOjg6IlRleHRhcmVhIjt9aTo4O2E6Mjp7czoyOiJpZCI7czoxMjoibWFwcGluZ19maWxlIjtzOjExOiJwbGFjZWhvbGRlciI7czoxMToiRmlsZSB1cGxvYWQiO31pOjk7YToyOntzOjI6ImlkIjtzOjE0OiJtYXBwaW5nX2hpZGRlbiI7czoxMToicGxhY2Vob2xkZXIiO3M6NjoiSGlkZGVuIjt9fQ=="><input
type="hidden" id="tve_mapping" name="tve_mapping" value="YTowOnt9"><input type="hidden" id="tve_labels" name="tve_labels" value="YToxOntzOjU6ImVtYWlsIjtzOjIwOiJUeXBlIFlvdXIgRW1haWwgSGVyZSI7fQ==">
</form>
Text Content
* Skip to main content * Skip to header right navigation * Skip to site footer My Online Training Hub Learn Dashboards, Excel, Power BI, Power Query, Power Pivot Menu * Courses * Pricing * Free Courses * Power BI Course * Excel Power Query Course * Power Pivot and DAX Course * Excel Dashboard Course * Excel PivotTable Course – Quick Start * Advanced Excel Formulas Course * Excel Expert Advanced Excel Training * Excel Tables Course * Excel, Word, Outlook * Financial Modelling Course * Excel PivotTable Course * Excel for Customer Service Professionals * Excel for Operations Management Course * Excel for Decision Making Under Uncertainty Course * Excel for Finance Course * Excel Analysis ToolPak Course * Multi-User Pricing * Resources * Free Downloads * Excel Functions Explained * Excel Formulas * Excel Add-ins * IF Function * Excel IF Statement Explained * Excel IF AND OR Functions * IF Formula Builder * Time & Dates in Excel * Excel Date & Time * Calculating Time in Excel * Excel Time Calculation Tricks * Excel Date and Time Formatting * Excel Keyboard Shortcuts * Excel Custom Number Format Guide * Pivot Tables Guide * VLOOKUP Guide * ALT Codes * Excel VBA & Macros * Excel User Forms * VBA String Functions * Members * Login * Blog * Excel Webinars * Excel Forum * Register as Forum Member * * Search Search siteSubmit search * Courses * Pricing Sub Menu * Free Courses * Power BI Course * Excel Power Query Course * Power Pivot and DAX Course * Excel Dashboard Course * Excel PivotTable Course – Quick Start * Advanced Excel Formulas Course * Excel Expert Advanced Excel Training * Excel Tables Course * Excel, Word, Outlook * Financial Modelling Course * Excel PivotTable Course * Excel for Customer Service Professionals * Excel for Operations Management Course * Excel for Decision Making Under Uncertainty Course * Excel for Finance Course * Excel Analysis ToolPak Course * Multi-User Pricing * Resources Sub Menu * Free Downloads * Excel Functions Explained * Excel Formulas * Excel Add-ins * IF Function Sub Menu * Excel IF Statement Explained * Excel IF AND OR Functions * IF Formula Builder * Time & Dates in Excel Sub Menu * Excel Date & Time * Calculating Time in Excel * Excel Time Calculation Tricks * Excel Date and Time Formatting * Excel Keyboard Shortcuts * Excel Custom Number Format Guide * Pivot Tables Guide * VLOOKUP Guide * ALT Codes * Excel VBA & Macros * Excel User Forms * VBA String Functions * Members Sub Menu * Login * Blog * Excel Webinars * Excel Forum Sub Menu * Register as Forum Member * EXCEL EOMONTH FUNCTION You are here: Home / Excel Formulas / Excel EOMONTH Function March 27, 2012 by Mynda Treacy Continuing on from last week’s EDATE function, today we’re looking at the Excel EOMONTH function. If you use Excel to generate invoices and your payments are due at the end of the month you can use the EOMONTH function to automatically enter the payment due date. EXCEL EOMONTH FUNCTION =EOMONTH(start_date,months) Returns the serial number of the last day of the month before or after a specified number of months. EXCEL EOMONTH FUNCTION EXAMPLES Note: only whole numbers are recognised by the 'months' argument. e.g. 1.7 months would be rounded down to 1. Tip 1: EOMONTH works with dates stored as text (e.g. cell B14 in the image above), but this is not reliable. It's always best to work with date serial numbers. Tip 2: There's no 'STARTOFMONTH' function, but you can also use EOMONTH to find the start of a month, e.g. let's say your 'start date' is 30th January and you want to return 1st January. You simply use EOMONTH to find the end of the previous month and then add 1: Formula: =EOMONTH(DATE(2017,01,30), -1) +1 Result: = 1st January 2017 Tip 3: Calculate End of Month Date from Today =EOMONTH(NOW(),0) Use this on invoice templates where invoices are due at the end of the month. Or if your credit terms are EOM+30 days then use: =EOMONTH(NOW(),1) Note: if the date displays as a serial number simply change the formatting to a Date format. CTRL+1 to open formatting dialog box. More on working with date and time in Excel FREE EBOOK - WORKING WITH DATE & TIME IN EXCEL Everything you need to know about Date and Time in Excel - Download the free eBook and Excel file with detailed instructions. Enter your email address below to download the comprehensive Excel workbook and PDF. Get Files By submitting your email address you agree that we can email you our Excel newsletter. Please enter a valid email address. Download the Excel Workbook and PDF. Note: This is a zip file including an Excel workbook with detailed instructions and a PDF version for your reference. MORE EXCEL DATES & TIME POSTS EXCEL EDATE FUNCTION Excel EDATE Function rolls a date forward or back based on the number of months you specify. It's great for calculating due dates etc. MORE EXCEL FORMULAS POSTS EXCEL FORMULA BY EXAMPLE Excel can now write a formula by example. Simply give it an example or two of the result and Excel will write the formula. AI AIDED EXCEL FORMULA EDITOR Save time with this free AI Excel formula editor add-in that writes, edits, improves and interprets formulas for you! TOP EXCEL FUNCTIONS FOR DATA ANALYSTS Must know Excel Functions for Data Analysts and what functions you don’t have to waste time learning and why. EXCEL ADVANCED FORMULA ENVIRONMENT Excel Advanced Formula Environment is a long awaited, new improved way to write, name and store Excel formulas. PRO EXCEL FORMULA WRITING TIPS Must know Excel formula writing tips, tricks and tools to make you an Excel formula ninja, including a new formula editor. NEW ARRAY SHAPING EXCEL FUNCTIONS The Excel Shaping Array Functions makes it easier than ever to reshape arrays and ranges using these purpose built functions EXCEL IF FORMULAS AND WHAT NOT TO DO Excel IF formulas can get out of hand when you nest too many IFs. Not only do they become unwieldy they’re difficult for anyone to understand EXCEL IMAGE FUNCTION The Excel IMAGE Function enables you to embed images in a cell using a formula. It supports BMP, JPG/JPEG, GIF, TIFF, PNG, ICO, and WEBP files EXCEL VSTACK AND HSTACK FUNCTIONS New Excel VSTACK and HSTACK functions makes combining arrays of cells easy and with some clever tricks we can extend their capabilities. IDENTIFY OVERLAPPING DATES AND TIMES IN EXCEL How to identify overlapping dates and times in Excel with a formula that checks a range of cells. Works with Dates and Times. Category: Excel FormulasTag: Excel dates & time Previous Post:Excel EDATE Function Next Post:Excel Go To Special is Very Special Indeed! READER INTERACTIONS COMMENTS 1. Ajab January 7, 2019 at 2:09 am Please I need in urdu Reply * Philip Treacy January 7, 2019 at 9:26 am Sorry we don’t have a translation Reply 2. René July 14, 2015 at 10:11 pm Hi Mynda, In a related post (Excel Formula to Spread Income or Costs Over Months, I was going through your posts :-)) you use EOMONTH also. That reminded me of a inconcequence in this function: it is not really the end of month. You miss a complete day. Is this a known issue? I discovered this by accident when reporting incidents. These incidents were tracked by the system in a date – time stamp. I noticed a certain difference between my report and the data from the system. I then formatted EOMONTH date in a format, and the end date was 2015-07-31 0:00:00, where you would expect 2015-07-31 23:59:59. So I ended up by adding 0,999994 to the EOMONTH date… Or of course add 1 to the dat, and don’t include this in your formula, like …<EOMONTH(,0)+1 in stead of <=EOMONTH René Reply * Mynda Treacy July 14, 2015 at 10:56 pm Hi René, Great to see you’re continuing your Excel education 🙂 The EOMONTH function can cause a day loss if you then use it in a calculation, however it depends on your need for it. If you wanted to return the actual date of the end of the month then it does just that. However, if you want to subract this date from another and count the last day of the month then you need to adjust for that day. This ‘inconsequence’ is apparent in any date calculation. Kind regards, Mynda Reply * René July 14, 2015 at 11:50 pm Hi Mynda, Education in Excel is an on-going process. There are times I think I have reasonable knowledge, but then I come across a solution so clever I never could have thought of myself. That puts me back on the ground, which is a good thing :-). Anyway, I like to improve, and reconsider my solutions for better ones. As for date calculations, most of the time I am happy with just the date. But I would expect that EOMONTH really gives the (end of) last day, not the beginning of the last day. It is just good to know it is not, for cases where it really matters. Another solution could be replacing the date+time formatted date with the integer of the date. Cheers, René Reply * Mynda Treacy July 15, 2015 at 9:44 am “Education in Excel is an on-going process.” Sure is. That’s one of the things I like about it. Reply 3. Nik Alexander April 8, 2015 at 1:54 am I have tried the suggestion above, eomonth(now(),1) but it is not quite giving me what I need. I want to know the due date of a invoice based on the date the invoice was raised. If this is a historical date, the ‘now’ option does not work. I need something like eomonth(‘invoice date’ + 30 days). Any ideas? Thanks Reply * Mynda Treacy April 8, 2015 at 9:10 am Hi Nik, Replace NOW() with your invoice date. e.g. =EOMONTH(invoice date, 0)+30 Kind regards, Mynda Reply * Nik Alexander April 20, 2015 at 9:47 pm That has fixed it. Many thanks, Mynda. 🙂 Reply * Mynda Treacy April 20, 2015 at 10:08 pm Awesome! Reply 4. Oliveiro May 6, 2014 at 3:45 pm Like this site, it is very informative. Is there a year function, as I need to reset counter to 001 at the change of every year. Reply * Catalin Bombea May 6, 2014 at 11:38 pm Hi Oliveiro, Yes, there is a YEAR() Function, which returns the year of the cell indicated in function argument. Please upload a sample of your calculations to help us understand what are you trying to achieve, what counter are you trying to reset, as EOMONTH is showing the date from the end of the month from the indicated cell? Use our Help Desk to send us a sample file, i will gladly help you. Cheers, Catalin Reply LEAVE A REPLY CANCEL REPLY Your email address will not be published. Required fields are marked * Comment * Name * Email * Website Save my name, email, and website in this browser for the next time I comment. Current ye@r * Leave this field empty SIDEBAR Search More results... No products in the cart. FEATURED CONTENT * 10 Common Excel Mistakes to Avoid * Top Excel Functions for Data Analysts * Secrets to Building Excel Dashboards in Less Than 15 Minutes * Pro Excel Formula Writing Tips * Hidden Excel Double-Click Shortcuts * Top 10 Intermediate Excel Functions * 5 Pro Excel Dashboard Design Tips * 5 Excel SUM Function Tricks * 239 Excel Keyboard Shortcuts Download Free Tips & Tricks SUBSCRIBE TO OUR NEWSLETTER Receive weekly tutorials on Excel, Power Query, Power Pivot, Power BI and More. Name: Email: We respect your email privacy Download Free PDF Hi, I'm Mynda Treacy and I run MOTH with my husband, Phil. Through our blog, webinars, YouTube channel and courses we hope we can help you learn Excel, Power Pivot and DAX, Power Query, Power BI, and Excel Dashboards. BLOG CATEGORIES * Excel * Excel Charts * Excel Dashboard * Excel Formulas * Excel PivotTables * Excel Shortcuts * Excel VBA * General Tips * Online Training * Outlook * Power Apps * Power Automate * Power BI * Power Pivot * Power Query COMPANY * About My Online Training Hub * Disclosure Statement * Frequently Asked Questions * Guarantee * Privacy Policy * Terms & Conditions * Testimonials * Become an Affiliate SUPPORT * Contact * Forum * Helpdesk – For Technical Issues Copyright © 2023 · My Online Training Hub · All Rights Reserved. Microsoft and the Microsoft Office logo are trademarks or registered trademarks of Microsoft Corporation in the United States and/or other countries. Product names, logos, brands, and other trademarks featured or referred to within this website are the property of their respective trademark holders. Download A Free Copy of 100 Excel Tips & Tricks Download My eBook We respect your privacy. We won’t spam you. x 74 Shares Share Tweet Pin Share Share Print Share Email Share My Online Training Hub Data and Cookie Consent In order to provide a more personal user experience, we and our partners use technology such as cookies to store and/or access device information. By clicking “Accept” you consent to these technologies which will allow us and our partners to process non-sensitive data such as IP address, unique ID, and browsing data for the purposes of serving personalized ads and content, ad and content measurement, audience insights, and to develop and improve products. Your choices on this site will be applied only for this site. You can change your settings at any time, including withdrawing your consent, by going to the Privacy Policy page of this site. Manage Settings Accept Update Privacy Settings