Comparing cells written in text to cells producing text from a for

[David B]

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

 

[Tom Hutchins]

Try
=IF(A1=TEXT(B1,"ddd"),TRUE,FALSE)

Hope this helps,

Hutch