Using the EOMONTH function, you can easily calculate the date at the end of the following month based on a specific date. It's a convenient function that's perfect for payment management. This time, I would like to consider how to use this function to identify the 10th day of the following month.
Related article Payment management in Excel, perfect time saving EOMONTH function with a function to specify the date at the end of the next month Date / time function= EOMONTH (start date, month)
Calculates the serial number corresponding to the last day of the month before or after the specified month, counting from the start date.
(1) Start date Specify the serial value of the date that will be the start date of the calculation. (2) Specify the number of months calculated from the start date of the month.
Add 10 at the end of the previous month
The figure below shows the date at the end of the following month calculated using the EOMONTH function based on the billing date. C2 is "= EOMONTH (A2,1)". A2 of the argument "start date" is "2021/9/15", and the argument "month" is "1". Therefore, since it is the end of the month following September, "2021/10/31" is returned to C2. Using the EOMONTH function in this way, you can easily identify the date at the end of the month.
Specified the date of the end of the month following the billing date [Click the image to enlarge]In fact, by editing this formula a little, it can be calculated for Ochanoko, such as the 10th of the month following the billing date. After selecting C2, add "+10" to the end of "= EOMONTH (A2,1)" to make the formula "= EOMONTH (A2,1) +10". When I pressed the [Enter] key, "2021/11/10" was returned. This is the 10th of the month following "2021/9/15", which is the "billing date". All you have to do is autofill this C2 to C6.
The 10th day of the month following the billing date was calculated. If you add 10 to the date at the end of the next month, you can identify the 10th day of the month after next [Click the image to enlarge]"= EOMONTH (A2,1)" returns the date at the end of the following month. The 10th day of the following month is nothing but the date of the end of the following month plus 10 days. Therefore, if "= EOMONTH (A2,1) +10" is set, the date of the 10th day of the following month will be returned.
You will need to register as a Nikkei Crosstech Active member in the future.
Nikkei Cross-Tech Active is an information site that supports the selection and introduction of products and services for companies involved in the IT / manufacturing / construction fields. A lot of contents such as product / service information and case studies are posted. When viewing for the first time, please register as a member (free of charge).
