IF formula weekend

[svinet]

Hi Everyone,
I’m having difficulties writing an IF formula that will shows the word “Weekend” and if the date in cell falls on a weekend and vice versa for the Weekday.

[AlKey]

Enter date in A1 and ust this formula

=IF(OR(WEEKDAY(A1)={1,7}),"Weekend","Weekday")

[Ron Coderre]

Try this for a date in A1

Please Login or Register  to view this content.

Is that something you can work with?

[svinet]

Thank You so much