Results 1 to 5 of 5
  1. #1
    Silver Lounger
    Join Date
    Jan 2002
    Posts
    1,615
    Thanks
    0
    Thanked 1 Time in 1 Post

    Last day of Month (2002)

    Hi,

    How do I find the last day of the month. IE if the date in cell a1 is 2/1/05, what would I use for a formula to find that last day of the month?

    Thanks,
    Leesha

  2. #2
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Last day of Month (2002)

    =DATE(YEAR(A1),MONTH(A1)+1,0)
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

  3. #3
    Silver Lounger
    Join Date
    Jan 2002
    Posts
    1,615
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Last day of Month (2002)

    Thanks! Worked like a charm.

    Leesha

  4. #4
    Star Lounger
    Join Date
    Feb 2003
    Posts
    89
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Last day of Month (2002)

    With the Analysis ToolPak,

    =EOMONTH(A1,0)

  5. #5
    Silver Lounger
    Join Date
    Jan 2002
    Posts
    1,615
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Last day of Month (2002)

    Hi,

    When I did a search prior to posting my question I found some code referring to EOMonth but then couldn't get it to work. I didn't realize it was part of the Analysis toolpak.

    Thanks!

    Leesha

Posting Permissions

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