Simple Excel problem

[MGBRoadster]

I have a date in cell A1 of 29/11/04
The cell is formatted >>custom>>ddd so that it reads "Mon"
I have some data in cell B1, and if cell A1 says "Mon" I want that data in cell C1

The formula I've written in C1 is:
=IF(A1="Mon", B1, " ") but it doesn't work

Am I doing something stoopid, or is there another way I can collect data from days of the week?

 

[pogle]

You need

=if(TEXT(A1,"ddd")="Mon",B1," ")

HTH

pogle

 

[MGBRoadster]

You need

=if(TEXT(A1,"ddd")="Mon",B1," ")

HTH

pogle

Thanks Pogle

 

[TWI]

More generic alternative

=if(weekday(A1) = 2, B1,"")

weekday 1=sun to 7=sat

 

[FetteredChinos]

though you can alter the weekday function to make monday=1 , which is usually easier to track


=weekday(a1,2)


voila.