Results 1 to 4 of 4

Thread: getting wrong previous quarter
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    Board Regular
    Join Date
    Feb 2013
    Posts
    360
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Default getting wrong previous quarter

    i have this:

    =WORKDAY(EOMONTH(p_quarter,MOD(-MONTH(p_quarter),3)-3),-1,holidays) , which gives me 12/28/18, but I'm looking for 12/31/18 since that is the last business day of the quarter, not 28.

    "p_quarter" is currently 3/29/19 ....
    Last edited by daveyc18; Jul 17th, 2019 at 05:26 PM.

  2. #2
    Board Regular
    Join Date
    Feb 2002
    Location
    Calgary, Alberta Canada
    Posts
    3,739
    Post Thanks / Like
    Mentioned
    3 Post(s)
    Tagged
    1 Thread(s)

    Default Re: getting wrong previous quarter

    Why does your formula have -1?

  3. #3
    MrExcel MVP Tetra201's Avatar
    Join Date
    Oct 2016
    Posts
    3,391
    Post Thanks / Like
    Mentioned
    15 Post(s)
    Tagged
    1 Thread(s)

    Default Re: getting wrong previous quarter

    Try

    =WORKDAY(EOMONTH(p_quarter,MOD(-MONTH(p_quarter),3)-3)+1,-1,holidays)

  4. #4
    Board Regular
    Join Date
    Feb 2013
    Posts
    360
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Default Re: getting wrong previous quarter

    Quote Originally Posted by Dave Patton View Post
    Why does your formula have -1?
    that's what I'm used to ...should it be 0 ? let me test

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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