View Single Post
  #3   Report Post  
Biff
 
Posts: n/a
Default

Hi!

One way:

=IF(WEEKDAY(A1,2)5,"Weekend","")

Will return Weekend if the date in cell A1 is on the weekend, otherwise,
returns blank.

Biff

"Cathy Landry" wrote in message
...
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