Try this:

=IF(OR(WEEKDAY(A1)=1,WEEKDAY(A1)=7),"Weekend","Wee kday")

"Cathy Landry" wrote:

Hello,

I have two columns with dates. Column A = Transaction Date and Column B =
Post Date. Is it possible to use a formula to identify those transactions (
A) that occurred on a weekend?

Thank you!
Cathy