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

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

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