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.
Tagged:
0
Best Answer
-
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)))
0
Answers
-
0
