Barb, thank you for the quick response! That worked!!! When you have time,
would you mind looking at my other post from 08/19 (required fields with
comments)?
Thank you again!
"Barb Reinhardt" wrote:
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
|