How to return the day os the week (e.g. "Monday") based on the date of the module
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!
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!0
I think the function you need to use is 'WEEKDAY'
Here you go →
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?0
Hello @Brfonseca ,
Many thanks @BrunoRodriguez !!0