How to use the EOMONTH function in Excel
How to use the EOMONTH function in Excel
Learn how to use the EOMONTH function in Microsoft Excel. This tutorial demonstrates how to use Excel EOMONTH with an easy to follow example. Never have trouble calculating the last day of the month again!
EOMONTH Function (and sample data):
https://www.techonthenet.com/excel/fo…
Excel Tutorials:
https://www.techonthenet.com/excel/in…
Don’t forget to subscribe to our channel for more great Excel tutorials!
Visit us at: https://www.techonthenet.com
or follow us on:
Facebook: https://www.facebook.com/techonthenetcom
Twitter: https://twitter.com/tech_on_the_net
Pinterest: https://www.pinterest.com/techonthene…
Content
0.04 -> The EOMONTH function is a Date function
in Excel that you will find very useful
6.44 -> It allows you to calculate
the last day of the month
9.628 -> after adding a specified number of months to a date value
13.46 -> To illustrate how the EOMONTH function works,
let's look at an example
18.22 -> Here we have a table of data that lists
a start date and a number of months
23.2 -> Let's use the EOMONTH function
to calculate the last day of the month
27.7 -> by adding the number of months
to the corresponding start date
31.2 -> Let's begin by entering the
EOMONTH command
35.282 -> As you can see,
the EOMONTH function takes 2 parameters
39.6 -> The first parameter we must enter
is the starting date to use in the calculation
45.28 -> In this example, let's enter
A2 as the first parameter
50.64 -> Cell A2 contains
the value Jan 26, 2016
55.94 -> Next we must provide the number of months
to add to the start date
59.98 -> In this example, we'll enter B2
which contains the value 0
64.7 -> Now that we have entered all
of the parameters for the EO month function
69.2 -> Let's complete the command
to look at our result
71.82 -> Notice that the EOMONTH function returns the result
as a serial date value and not as a string date value
78.86 -> A serial date is how Excel
stores dates internally
82.58 -> and it represents the number of days
since Jan 1, 1900
87 -> As you can see, the serial date value
42400 appears in cell C2
93.52 -> 42400 is a serial date value
that is equal to Jan 31, 2016
100.38 -> This value is calculated by taking
the date Jan 26, 2016 adding 0 months
107.46 -> and then returning
the last day of the month
110.04 -> Let's quickly apply
a date format to column C
113.76 -> so that you can see our result
in a more readable format
117.74 -> To do this, right-click on column C
and select "Format Cells" from the pop-up menu
123.66 -> Choose one of the date formats
or create a custom format
127.7 -> In this example, we will create a custom format
to display our dates as month day year
134.16 -> Now that we have
applied our date format
136.86 -> we can see the value Jan 31, 2016 displayed in cell C2
instead of the serial date value 42400
146.18 -> Let's copy our formula
into cells C3 to C5
151.38 -> Now each of the cells in C3, C4 and C5 will display
the calculated last day of the month
158.22 -> by adding the number of months
to the start date
161.66 -> This completes our example of how to
use Excel's EOMONTH function
165.84 -> If you would like to see
more EOMONTH examples
168.84 -> or would like to download
the sample data we used for this tutorial
171.72 -> please visit our website at
TechOnTheNet.com
174.82 -> If you found our tutorial,
helpful please leave a like on this video
179.4 -> and don't forget to subscribe
to our YouTube channel for more great Excel tutorials
Source: https://www.youtube.com/watch?v=AaMlUse0t1c