Results 1 to 3 of 3
  1. #1
    Join Date
    Oct 2003
    Posts
    311

    Unanswered: last day of month?

    how can i get the last day of a month? Is there a function?

  2. #2
    Join Date
    Oct 2003
    Posts
    1,091
    I think this is in the Analysis ToolPak: EOMONTH

    Suppose your date is in cell B1, then use

    =EOMONTH(B1,1)

    1 refers to number of months after that given date in B1. If you want the same month, use 0. Be sure to format your cell as date, otherwise it will be a serial number.
    old, slow, and confused
    but at least I'm inconsistent!

    Rich
    (retired Excel 2003 user, 3/28/2008)

    How to ask a question on forums

  3. #3
    Join Date
    Mar 2006
    Posts
    163
    Try this.

    =DATE(YEAR(A1), MONTH(A1)+1, 0)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •