+ Reply to Thread
Results 1 to 4 of 4

Return End of Month Date Based on Another Date Input

  1. #1
    Registered User
    Join Date
    08-12-2012
    Location
    Canada
    MS-Off Ver
    Excel 2010
    Posts
    2

    Return End of Month Date Based on Another Date Input

    Hello,

    need to take dates in one column and show the last business day within that month for each value in another column. Please forgive my lack of knowledge with Excel and help. Thank you.

  2. #2
    Forum Moderator dominicb's Avatar
    Join Date
    01-25-2005
    Location
    Lancashire, England
    MS-Off Ver
    MS Office 2000, 2003, 2007 & 2016 365
    Posts
    4,867

    Re: Return End of Month Date Based on Another Date Input

    Good afternoon bcomrie

    ...and welcome to the forum!!

    Try :
    Formula: copy to clipboard
    Please Login or Register  to view this content.


    HTH

    DominicB

  3. #3
    Forum Moderator daddylonglegs's Avatar
    Join Date
    01-14-2006
    Location
    England
    MS-Off Ver
    2016
    Posts
    14,676

    Re: Return End of Month Date Based on Another Date Input

    Quote Originally Posted by bcomrie View Post
    ....the last business day within that month
    Your formula will give the last day of the month, Dominicb, assuming business days are Monday to Friday then with date in A2 try this formula in B2 to get last business day

    =WORKDAY(EOMONTH(A2,0)+1,-1)

    If you want to exclude holidays as well as weekends then with list of holiday dates in H2:H10 change to

    =WORKDAY(EOMONTH(A2,0)+1,-1,H$2:H$10)
    Audere est facere

  4. #4
    Registered User
    Join Date
    08-12-2012
    Location
    Canada
    MS-Off Ver
    Excel 2010
    Posts
    2

    Re: Return End of Month Date Based on Another Date Input

    thanks guys, worked!

+ Reply to 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