How to return the day os the week (e.g. "Monday") based on the date of the module

Brfonseca

Hi,

I have module with time scale "day". I have a line item called: Workday, and I need it to return the day of the week (e.g. "Monday") based on the date of the module. I need this so that the person has to tick only the weekdays.

Can you help me ?

Thank you in advance!

BrunoRodriguez

Hello @Brfonseca,

I believe you are after something like the below?

In such a case, you need to create a fake list for the days as per below:

And then the last step would be to make a FINDITEM. Remember that it requires text, so you would need to convert the "Year text" into text. You can use TEXT() to do so.

Finally, if the day number that goes from 1 to 7 is below equal or below 5, a boolean could be ticked.

I hope the above is clear!

aakash

Hi @Brfonseca,

I think the function you need to use is 'WEEKDAY'

Here you go → https://help.anaplan.com/a445eb44-98b7-4abc-8748-92435187e423-WEEKDAY

Regards,

Aakash Sachdeva

Brfonseca

Hello @BrunoRodriguez , That's exactly what I want! Thank you !!
Can you show me the module in blueprint mode, in order for me to check the formulas of each line item, please?

BrunoRodriguez

Hello @Brfonseca ,

Cheers!

Brfonseca

Many thanks @BrunoRodriguez !!