Excel automation - how to distinguish weekends

Help Studio
1

Hello. Is there a way to distinguish weekends in Excel?
I have Excel file with more than 70 thousands rows and should find way to separate working days from weekends inside date column.
Is it possible?

2

or using
Weekday function that returns a value between 1 and 7 corresponding to the value of the day of the week .

3

Should be pretty easy. How is your column formatted? MM/dd/yyyy? Mon,Wed,Thurs, Sat?

4

dd.MM.yyyy