If a date is in A1, then =WEEKDAY(A1,2)) will return 6 for Saturday and 7 for
Sunday. So
=IF(WEEKDAY(A1,2)5,"weekend","")
--
Gary's Student
"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
|