formula to display Last Week, This Week
Results 1 to 5 of 5

Thread: formula to display Last Week, This Week

  1. #1
    Board Regular pcorpz's Avatar
    Join Date
    Oct 2004
    Posts
    317
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default formula to display Last Week, This Week

    =IF(H2<TODAY()-14,"Old",IF(H2<TODAY()-7,"Last Week", "This Week"))

    I found this formula and my only issue is that I want the week to start from Monday to Sunday.. for last week and this week.
    Last edited by pcorpz; Aug 8th, 2019 at 07:18 PM.

  2. #2
    Board Regular Sam_D_Ben's Avatar
    Join Date
    Oct 2012
    Location
    New Jersey, USA
    Posts
    371
    Post Thanks / Like
    Mentioned
    4 Post(s)
    Tagged
    0 Thread(s)

    Default Re: formula to display Last Week, This Week

    Something like this function.

    Excel 2013/2016
    AB
    1DateWeek Starting Monday
    2Thursday, August 08, 2019Monday, August 05, 2019

    Sheet1



    Worksheet Formulas
    CellFormula
    B2=A2-WEEKDAY(A2,2)+1

    Sam_D_Ben

  3. #3
    Board Regular pcorpz's Avatar
    Join Date
    Oct 2004
    Posts
    317
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: formula to display Last Week, This Week

    Quote Originally Posted by Sam_D_Ben View Post
    Something like this function.

    Excel 2013/2016
    AB
    1DateWeek Starting Monday
    2Thursday, August 08, 2019Monday, August 05, 2019

    Sheet1



    Worksheet Formulas
    CellFormula
    B2=A2-WEEKDAY(A2,2)+1
    A helper column! Got it. =D Thank you!

  4. #4
    Board Regular
    Join Date
    Apr 2016
    Location
    Vietnam
    Posts
    123
    Post Thanks / Like
    Mentioned
    3 Post(s)
    Tagged
    0 Thread(s)

    Default Re: formula to display Last Week, This Week

    Or try

    =IF(WEEKNUM(TODAY(),2)=WEEKNUM(H3,2),"This Week",IF(WEEKNUM(TODAY()-7,2)=WEEKNUM(H3,2),"Last Week"))

  5. #5
    Board Regular pcorpz's Avatar
    Join Date
    Oct 2004
    Posts
    317
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: formula to display Last Week, This Week

    Quote Originally Posted by Phuoc View Post
    Or try

    =IF(WEEKNUM(TODAY(),2)=WEEKNUM(H3,2),"This Week",IF(WEEKNUM(TODAY()-7,2)=WEEKNUM(H3,2),"Last Week"))
    Phuoc, this works!! I was trying to accomplish to write this. Thanks so much!!

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
  •