Hello how are you?
how can I sumarize a column the date by working date?
@LETICIAHELENA First you need to find out whether the given date is a working date or not. This can be done with the help of the formula DateTimeFormat([Date Field],'%A'), this formula will give you the name of the day. Then you can filter out the working days using a filter tool, then use the summarise tool - group by [Date Field]. If the explanation doesn't help provide a sample file and expected output file, will create a workflow for you.
@binuacs my excel is attached also I have a list of the dates.
I need to sumarize saturday and sunday in the monday
@LETICIAHELENA I did not fully understand the requirement, based on my understanding I created a workflow and attached it. I converted the date field into days and summarised. If you are looking for only particular days you can add a filter tool before the summarise tool and filter out the days you are looking for. If you can provide which are the fields to be used in summarise tool let me know so I can update the workflow, also I am not sure if the calendar sheet should be considered here or not
@binuacs my excel file has bank data on saturday and sunday i need these days to be counted as the next business day, in the case of monday and if there is a holiday follow the same rule so i thought of using the calendar, but i don't know how to do this sum of weekend and add on the second or next business day.