Closed Thread
Results 1 to 8 of 8

Finding the Last Day of a Given Month

  1. #1
    barbarr
    Guest

    EOMONTH

    I think you need to mention that the Analysis ToolPak Add-In needs to be installed before the EOMONTH() function is available.

    If not sure that the Analysis ToolPak Add-In is installed, then the safest formula to use is your second one:
    =DATE(YEAR(TODAY()),MONTH(TODAY())+num_mths,0) where num_mths = 0 for the end of month for the current month and num_mths = 1 for the end of the month for the next month, etc.

  2. #2
    Deepak
    Guest

    Date function use

    I think in the third formula, if the date in Col. A is December, then using A2+1 is bound to give error. Please clarify on dsugandhi@vsnl.net

  3. #3
    MohanaSundaram G
    Guest

    Date function use

    =DATE(YEAR(TODAY()),MONTH(TODAY())+num_mths,0) where num_mths = 0 for the end of month for the current month and num_mths = 1 for the end of the month for the next month, etc.
    1. Tried the formula if num_months = 0, it gives the end date for the previous month and if num_months = 1, it gives the end date for the current month
    2. To get the EO month the formula should be DAY(DATE(YEAR(TODAY()),MONTH(TODAY())+num_mths,0)
    3. The third formula DATE(2005,A2+1,0) does seem to work

  4. #4
    MohanaSundaram G
    Guest

    Date function use

    =DATE(YEAR(TODAY()),MONTH(TODAY())+num_mths,0) where num_mths = 0 for the end of month for the current month and num_mths = 1 for the end of the month for the next month, etc.
    1. Tried the formula if num_months = 0, it gives the end date for the previous month and if num_months = 1, it gives the end date for the current month
    2. To get the EO month the formula should be DAY(DATE(YEAR(TODAY()),MONTH(TODAY())+num_mths,0)
    3. The third formula DATE(2005,A2+1,0) does seem to work

  5. #5
    roomi
    Guest

    valubale suggestion

    I would request to all those who give excel tips and the ones who post it on this forum to list their tip/suggestion with example. That way it will be a lot easier for less advance excel user to understand the working of it in a real example and than able to apply whenver the face that particular situation.

    Thanks to all.

  6. #6
    Forum Contributor
    Join Date
    12-07-2004
    Posts
    596

    Finding the Last Day of a Given Month

    Problem:

    Calculating the date at the end of the current month, as well as the date at the end of each month (serial number) listed in column A.

    Solution:

    To calculate the date at the end of the current month, use the EOMONTH and TODAY functions as shown in the following formula:
    =EOMONTH(TODAY(),0)

    To calculate the date at the end of next month, use the EOMONTH and TODAY functions as shown in the following formula:
    =EOMONTH(TODAY(),1)

    To calculate the date at the end of each month listed in column A, use the DATE function as shown in the following formula:
    =DATE(2005,A2+1,0)

  7. #7
    Registered User
    Join Date
    12-08-2005
    Posts
    1

    Analysis ToolPak Add-In

    You have to be sure anyone viewing your worksheet has the Analysis ToolPak Add-In installed, or that you have converted the formula to values (copy, paste special, values).

  8. #8
    Registered User
    Join Date
    12-08-2005
    Posts
    2

    Exclamation Finding the last day of a given month

    =DATE(YEAR(TODAY()),MONTH(TODAY())+num_mths,0) where num_mths = 0 for the end of month for the current month and num_mths = 1 for the end of the month for the next month, etc.
    1. Tried the formula if num_months = 0, it gives the end date for the previous month and if num_months = 1, it gives the end date for the current month
    2. To get the EO month the formula should be DAY(DATE(YEAR(TODAY()),MONTH(TODAY())+num_mths,0)
    3. The third formula DATE(2005,A2+1,0) does not seem to work

Closed Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1