Forum Discussion

vjnvinod's avatar
vjnvinod
Icon for Impactful Individual rankImpactful Individual
5 years ago
Solved

week start date and week end date

Hi 

 

I need to calculate week start date and week end date for  a calendar i am trying to build

my week starts on Saturday and week ends on Friday

 

I used week day function but i am getting error of year 1900 or something like that, see below screenshot

could you please help me how to find my week start date and week end date?

 

Need Help
Show and Tell
  • ryan_mayu's avatar
    ryan_mayu
    5 years ago
    pls try this
    Column = if(MONTH('Date'[Start])=7,"P1",if(month('Date'[Start])=8,"P2"))
    week = "Wk"&roundup(('Date'[Date]-MIN('Date'[Date])+1)/7,0)
     

11 Replies

    • vjnvinod's avatar
      vjnvinod
      Icon for Impactful Individual rankImpactful Individual
      5 years ago

      Greg_Deckler 

       

      thanks for the share, very overwhelming for me

      I just need a simple formula to calculate week starting day and week ending day

      week starts on saturday and week ends on friday

    • vjnvinod's avatar
      vjnvinod
      Icon for Impactful Individual rankImpactful Individual
      5 years ago

      ryan_mayu 

       

      that doesn't give me week start date 

      i am trying to create a coloumn for Week start date & week End date, my week starts with saturday and Week ends with Friday

      how do i write this formula

      I tried something like this, doesn't calcualtes correctly

      Week Start Date = 'Date'[Date]+6-WEEKDAY('Date'[Date],1)
      • ryan_mayu's avatar
        ryan_mayu
        Icon for Super User rankSuper User
        5 years ago

        vjnvinod 

        what's the expected output? shows "start" for weekstart date and "end" for weekend date?