cell value instead of formula?
 

Scenario:
B9: =WORKDAY(D$4,1,'SET UP'!Q$12:Q$30)
Q5: = B9 formatted as date 01/05/09
N5: = Q5 formatted as day Monday
G9: =IF(('ADIMOOLAH,RILEY'!R$7)=$N$5,"FLEX","")
('ADIMOOLAH,RILEY'!R$7)= Monday

G9 won't return "FLEX" unless I key the word "Monday" in the cell. I am
assuming that it has something to do with looking at the formula in N5
instead of the result of the formula.

Other cells will be looking for a match with "Wednesday", others, "Friday".

How do I get this to work?

Thanks in advance

cell value instead of formula?
 

try this

=IF(('ADIMOOLAH,RILEY'!R$7)=Text(N$5,"dddd"),"FLEX ","")

On Feb 11, 2:21*am, Gator Girl
wrote:
Scenario:
B9: =WORKDAY(D$4,1,'SET UP'!Q$12:Q$30)
Q5: = B9 formatted as date 01/05/09
N5: *= Q5 formatted as day Monday
G9: *=IF(('ADIMOOLAH,RILEY'!R$7)=$N$5,"FLEX","")
('ADIMOOLAH,RILEY'!R$7)= Monday

G9 won't return "FLEX" unless I key the word "Monday" in the cell. *I am
assuming that it has something to do with looking at the formula in N5
instead of the result of the formula.

Other cells will be looking for a match with "Wednesday", others, "Friday".

How do I get this to work?

Thanks in advance

cell value instead of formula?
 

Hi,

Use
=TEXT(Q5,"dddd")
--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"Gator Girl" wrote:

Scenario:
B9: =WORKDAY(D$4,1,'SET UP'!Q$12:Q$30)
Q5: = B9 formatted as date 01/05/09
N5: = Q5 formatted as day Monday
G9: =IF(('ADIMOOLAH,RILEY'!R$7)=$N$5,"FLEX","")
('ADIMOOLAH,RILEY'!R$7)= Monday

G9 won't return "FLEX" unless I key the word "Monday" in the cell. I am
assuming that it has something to do with looking at the formula in N5
instead of the result of the formula.

Other cells will be looking for a match with "Wednesday", others, "Friday".

How do I get this to work?

Thanks in advance

cell value instead of formula?
 

Thank you for submitting, I didn't try yours, cause it would have involved a
lot more editing than Shane's suggestions, but I do appreciate your help.

"muddan madhu" wrote:

try this

=IF(('ADIMOOLAH,RILEY'!R$7)=Text(N$5,"dddd"),"FLEX ","")

On Feb 11, 2:21 am, Gator Girl
wrote:
Scenario:
B9: =WORKDAY(D$4,1,'SET UP'!Q$12:Q$30)
Q5: = B9 formatted as date 01/05/09
N5: = Q5 formatted as day Monday
G9: =IF(('ADIMOOLAH,RILEY'!R$7)=$N$5,"FLEX","")
('ADIMOOLAH,RILEY'!R$7)= Monday

G9 won't return "FLEX" unless I key the word "Monday" in the cell. I am
assuming that it has something to do with looking at the formula in N5
instead of the result of the formula.

Other cells will be looking for a match with "Wednesday", others, "Friday".

How do I get this to work?

Thanks in advance

cell value instead of formula?
 

Thank you! works like a charm. :)

"Shane Devenshire" wrote:

Hi,

Use
=TEXT(Q5,"dddd")
--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"Gator Girl" wrote:

Scenario:
B9: =WORKDAY(D$4,1,'SET UP'!Q$12:Q$30)
Q5: = B9 formatted as date 01/05/09
N5: = Q5 formatted as day Monday
G9: =IF(('ADIMOOLAH,RILEY'!R$7)=$N$5,"FLEX","")
('ADIMOOLAH,RILEY'!R$7)= Monday

G9 won't return "FLEX" unless I key the word "Monday" in the cell. I am
assuming that it has something to do with looking at the formula in N5
instead of the result of the formula.

Other cells will be looking for a match with "Wednesday", others, "Friday".

How do I get this to work?

Thanks in advance

cell value instead of formula?
 

Glad to help, and thanks for the feedback.



Cheers,
Shane Devenshire


"Gator Girl" wrote:

Thank you! works like a charm. :)

"Shane Devenshire" wrote:

Hi,

Use
=TEXT(Q5,"dddd")
--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"Gator Girl" wrote:

Scenario:
B9: =WORKDAY(D$4,1,'SET UP'!Q$12:Q$30)
Q5: = B9 formatted as date 01/05/09
N5: = Q5 formatted as day Monday
G9: =IF(('ADIMOOLAH,RILEY'!R$7)=$N$5,"FLEX","")
('ADIMOOLAH,RILEY'!R$7)= Monday

G9 won't return "FLEX" unless I key the word "Monday" in the cell. I am
assuming that it has something to do with looking at the formula in N5
instead of the result of the formula.

Other cells will be looking for a match with "Wednesday", others, "Friday".

How do I get this to work?

Thanks in advance