Calenday Days

DMManalili

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.

 

 

 

KirillKuznetsov

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)))

 

 

AntonMineev

Hi @DMManalili!

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

WEEKDAY