Calenday Days

DMManalili
Frequent Contributor

Calenday Days

Hi,

 

For your assistance please. How can I mimic the calendar in anaplan? my time period is Days but I need to get the specific weekdays equivalent (Monday to Sunday). I created a list of Monday to Sunday and just have a drop down list...how can I do it automatically in the formula? Thank you.

 

DMManalili_1-1627373679347.png

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
KirillKuznetsov
Certified Master Anaplanner

Re: Calenday Days

there is WEEKDAY() formula in Anaplan

https://help.anaplan.com/d8c2a977-b791-46bf-9178-9bb3f1414307-WEEKDAY

Create one line item with the format of your weekdays list, one line item with date format and add code of the list items equal to weekday number (1-7).

 

Then you will need a formula something similar to this:

Finditem(weekday list, text(weekday(date line item)))

 

 

View solution in original post

2 REPLIES 2
AntonMineev
Certified Master Anaplanner

Re: Calenday Days

Hi @DMManalili!

You can use WEEKDAY formula for it! And map it with your custom list.

WEEKDAY 

KirillKuznetsov
Certified Master Anaplanner

Re: Calenday Days

there is WEEKDAY() formula in Anaplan

https://help.anaplan.com/d8c2a977-b791-46bf-9178-9bb3f1414307-WEEKDAY

Create one line item with the format of your weekdays list, one line item with date format and add code of the list items equal to weekday number (1-7).

 

Then you will need a formula something similar to this:

Finditem(weekday list, text(weekday(date line item)))

 

 

View solution in original post