Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Accepted Solutions
Hello I had to translate the details in English so the translation might not be accurate, which means that I might have misunderstood the requirement. Please check the following details:
1. If your dataset looks like:
2. Then you can do something like that:
=date('2/7/2022','MM/DD/YYYY')- date('2/3/2022','MM/DD/YYYY') // Change the first part of each function to the date field of course. So in case you know the start date and end date you can calculate the number of days between them
3. Or if you want you can use:
=DayNumberOfYear('11/1/2022') // Which will give you the exact day number of the day within the year.
Output:
NOTE: The requirement that was unclear to me after translation is: "... a function that counts the days of the week". Perhaps the information above can help you use the mentioned functions in your use case scenario to make the needed calculations.
I hope that this information was helpful. In case I have misunderstood the use case scenario, please elaborate in details by providing additional information. However, if it has helped you resolve the issue, addressed your concerns or at least pointed you in the right direction, please mark it as Accepted Solution to give further visibility to other community members.
