How to check next day is weekend day or not

Yashwant Singh

HI team,

How to check that next day is Saturday or Sunday.

If end date will be come in Saturday or Sunday then processing task will be done by Friday only.. Is this possible using any formulas?

Andrée Starå

Hi @Yashwant Singh

Are you using dependencies on the sheet? If yes, it's not possible to use a formula in the end date column. We could add a so-called helper column to indicate/alert that the end date is on the weekend.

Also, we could set the working Days not to include weekends, which would be automatic if you use dependencies.

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

Yashwant Singh

actually, using formula if day is weekend then automatically increase in day Monday.

but in current requirement, if data filing due date day is Saturday then formula automatically alert or change day before week day...

Andrée Starå

@Yashwant Singh

Not sure I follow!

What formula do you have now?