Chat with us, powered by LiveChat

Tag Archives: date function

EOMONTH

Date Function
EOMONTH

EOMONTH screenshot

screenshot of a function dialog box

EOMONTH displays the serial number of the last day of the specified month.
You can use this to calculate maturity dates and due dates that occur on the last day of the month.
In the example below, I have 1/2/2016 in cell A1. In another cell, I have typed =EOMONTH(A1,2) which tells Excel to look at the date in cell A1 and display the serial date of the last day of two months out which is March 31, 2016.
I keep saying serial number. In the screenshot below it shows 42460 as the answer even though in the bottom of the dialog box you can see the Formula result is 3/31/2016. If you want to see the date format then you need to go to the number format and select Short Date or some other date format.
If I had typed =EOMONTH(A1,1) it would have displayed the serial number of one month out which would be February 29, 2016.  If I had typed =EOMONTH(A1,-1) then it would display 12/31/2015.

  • “Excellent Regulatory Review Course. The self-study format (E-Book) provided an excellent overview of the regulatory requirements for California CPAs. I will be using the E-Book as  a reference material. Thank you for providing a very comprehensive yet affordable option for this required CPE.”

    - Constance

  • Overall I was very pleased with the course. Previously I knew just enough about pivot tables to be dangerous. Now I see the power that they have and I feel much more confident using pivot tables. The course materials were very clear and well prepared. I’ll be looking at your website for future CPE hours.

    - Scott

  • Thank you Patricia. I really love your courses. I learned so much about excel this weekend!”

    - Connie K.