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
    Hi
    Is there any formula so I can get the "week start" or "week end" for each week number?
    Regards,
    Panos
  • 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.

    image
    Attachments
    WeekCommencing.JPG 113K

Welcome!

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

Sign In Apply for Membership