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!

Best Answer

  • BrunoRodriguez
    edited April 2023 Answer ✓

    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!

    Kind regards,

    Bruno Rodriguez