Forum Discussion

limewire's avatar
limewire
Helper I
7 years ago
Solved

Irregular Custom Calendar

Greetings!   I'm having trouble creating a calendar that will mimic a Broadcast calendar.    So I am trying to create a custom calendar where: Each week starts on a Monday and ends on a Sunday ...
Need Help
Tutorial Requests
  • Anonymous's avatar
    Anonymous
    7 years ago

    HI limewire ,

    You can refer to following calculated column formulas to achieve your requirements.

     

    #1:
    Week Num = WEEKNUM([Date],2)
    
#2:
Start from monday =
IF (
    WEEKDAY ( DATE ( YEAR ( [Date] ), MONTH ( [Date] ), 1 ), 2 ) = 1,
    "Normal"
)
    
#3:
Day of week= WEEKDAY([Date],2)
    
#4:
Week Index =
WEEKNUM ( [Date], 2 )
    - WEEKNUM ( DATE ( YEAR ( [Date] ), MONTH ( [Date] ), 1 ), 2 ) + 1

     

     

     

    Regards,

    Xiaoxin Sheng

Anonymous's avatar
Anonymous
Not applicable
7 years ago

HI limewire ,

You can refer to following calculated column formulas to achieve your requirements.

 

#1:
Week Num = WEEKNUM([Date],2)

#2:
Start from monday =
IF (
    WEEKDAY ( DATE ( YEAR ( [Date] ), MONTH ( [Date] ), 1 ), 2 ) = 1,
    "Normal"
)

#3:
Day of week= WEEKDAY([Date],2)

#4:
Week Index =
WEEKNUM ( [Date], 2 )
    - WEEKNUM ( DATE ( YEAR ( [Date] ), MONTH ( [Date] ), 1 ), 2 ) + 1

 

 

 

Regards,

Xiaoxin Sheng