Tem duas colunas, coluna Vencimento com datas aleatórias, e na outra coluna envio quero copia a data da coluna vencimento mas se essa data for domingo quero alterar ela para segunda-feira, se não for domingo mantém a mesma data, qual formula usar para saber que dia da semana é = a domingo e mudar para segunda-feira;
Hello @Sidney, at this stage, we only offer support in English here. For future posts, please write in English. 
I used the translator, and if I understood your request correctly, you are looking for a formula to check the value of the cell. If the value is Sunday, it should change to Monday; otherwise, keep the value as it is. Correct?
Yes, correct, I will send you an image to illustrate the scenario I need.
Hi,
You can check the day of the week using the following formula
datetime_format(field('date field'), 'D') = '1'
This returns true (shows a checkmark) if the value in the date field is on a Sunday and false if not.
frederikdc,
Thanks for the tip, I managed to solve it, the formula looked like this,
IF(datetime_format(field(‘Dom_D-3’), ‘D’) = 1, field(‘Dom_D-3’) + date_interval(‘P1D’), field(‘Dom_D-3’)), locking the result that I needed and keeping the dates that are not Sunday.
Grateful.
1 Like