Comparing cells written in text to cells producing text from a for
Try
=IF(A1=TEXT(B1,"ddd"),TRUE,FALSE)
Hope this helps,
Hutch
"David B" wrote:
Example: I hand enter Tue in A1. From a dated data entry I format cell C1 to
reflect the day of the week an action occurred, and abrv the format ie: Wed.
I need to compare A1 Tue to C1 Wed and get a true or false answer. This will
let me calculate the number of on time deliveries vrs missed.
David B
|