+ Reply to Thread
Results 1 to 2 of 2

Nestled EOMONTH function problem\nestled with more

Hybrid View

  1. #1
    Registered User
    Join Date
    04-18-2013
    Location
    US
    MS-Off Ver
    Excel 10
    Posts
    1

    Post Nestled EOMONTH function problem\nestled with more

    I have something incorrect in my formula. If A3 is on the worksheet, I need it to pull the last day of the quarter end of the next month. For example if the date in D3 on my schedule is 12/11/2012, if it is not on the worksheet, it should calculate to 12/31/2012. If the value Is on the worksheet, I need it to calculate to 03/31/2013. Currently it is calculating 12/31/2011 regardless whether or not A3 is found on the worksheet tab or not.

    =IF(ISNA(VLOOKUP(VALUE(A3),'worksheet'!B:E,3,FALSE)),EOMONTH(DATE(YEAR(D3),ROUNDUP(MONTH(D3)/3,0)*3,1),0),EOMONTH(DATE(YEAR(D3),ROUNDUP(MONTH(D3)/3,0)*3,1),0)+95-DAY(EOMONTH(DATE(YEAR(D3),ROUNDUP(MONTH(D3)/3,0)*3,1),0)+95))

    Anyone know where the mistake lies? Thanks!

  2. #2
    Forum Expert bebo021999's Avatar
    Join Date
    07-22-2011
    Location
    Vietnam
    MS-Off Ver
    Excel 2016
    Posts
    9,645

    Re: Nestled EOMONTH function problem\nestled with more

    I guess you 'd like to lookup A3 value in column D?
    If yes, do something like this:
    = IF(ISERROR(MATCH(A3*1,D:D,0)),EOMONTH (1), EOMONTH (2))
    If not, try to upload a small example with your desired result.
    Quang PT

+ 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