Calculation of weekdays (Saturday-Friday)


I want to create a card with downloads which should show the weekly development. For the week we don´t want to have the standard week (Monday-Sunday). We want to have for the week Saturday-Friday. Can you tell me how can i make the set ups in Beast Mode calculation?


Thanks a lot in advance!


  • Is anyone able to help out with this request?

  • Hi,


    The following Beast Mode will give you the week number (weeks starting on Saturday) for a given date:


    MOD(FLOOR((DATEDIFF(your_date_field,'2006-01-01' )-6)/7),52)+1


    Tell me how it went.

    Hope this helps.

  • If you need to do this on many cards and do not already have a fiscal calendar enabled you can reach out to our support team in order to create a fiscal calendar on cards that will do this for you without creating a beastmode.

This discussion has been closed.