Finding a vaule value from your string, NOW()

[Calvin]

What I am tring to do is create a cell that will look at my NOW() strin
and find ex: "*Monday*". My format for the NOW() cell is dddd d mm
yyy. What I have found out is that if I use a IF statement like such
IF (M2="*Monday*",L2,wrong) well need less to say that doesnt work. Pe
one one the users here suggested I use a COUNTIF and after some mor
research that only works if you know the exact value. Overall I woul
like to say IF a cell has Monday in the results take the vaule o
another cell and add it to this cell. Can anyone help me

 

[Frank Kabel]

Hi
try
=IF(WEEKDAY(M2,1)=2,L2,"no monday")

Frank

 

[Calvin]

I have been banging my head all day over this. Your answer now sets ou
all sorts of bells and whistles. Microsofts documentation was reall
clear to me, that last portion through me way off. For other newbie
like myself this is what the Excel explaination looks like
WEEKDAY(35981.007) equals 1 (Sunday), instead of what Frank has whic
now makes sense. Thanks Frank: