Visokio website     Downloads     Video tutorials     KnowledgeBase  
Formulae: Calculating Week Start - Week Ending dates? - Visokio Forums
Formulae: Calculating Week Start - Week Ending dates?
  •     Panos September 17, 2014 1:48PM
    Is there any formula so I can get the "week start" or "week end" for each week number?
  • 1 Comment
  •     paola September 17, 2014 2:20PM
    BUCKET([Date], 1, "week", "dd MMM yyyy")
    This formula can be used for output format like:
    26 Dec 2011 to 02 Jan 2012

    If the default week start/end dates do not fit with your company/industry - please see the Regional date settings, as these can be customised.
    Settings>Advanced file settings>Regional

    Using the same principle, you could create a new field [Week commencing], adding one more step.

    WeekCommencing.JPG 113K


It looks like you're new here. If you want to get involved, click one of these buttons!

Sign In Apply for Membership