How to refer to a data in a cell where the value is a formula

[crapit]

as above

 

[crapit]

I'm using it in conditional format. Cells custom format to "DDD" (w/o
quote)

A1 = 23/01/06 which give "MON"
B1 = A1 + 1 which give "TUE"
B2 using conditional formatting =B1="Tue", cell shading color = red

A B C
1 MON TUE
2
3

 

[sweet_dreams]

if you want to use value form the cell you simply have to give it's
address. it doesn't matter if there is a formula in cell or not

sweet_dreams

 

[Dave Peterson]

The value in the cell and what you see are two different things--especially with
dates (and numbers (like money)).

If you want to check to see if a date is a Tuesday:

=WEEKDAY(A1,2)=2

(Check excel's help for =weekday() and you'll see that that ",2" means start
counting with Monday = 1.

 

[Dave Peterson]

If you look at excel's help for =weekday(), you'll find one way:

=weekday(a1,1)=1
or
=weekday(a1,2)=7

 

[Dave Peterson]

If you put a date in a cell, then the value will always be the date.

You might see
January 23, 2006
or
1/23/2006
or
Jan 23, 2006
or
01232006

But if you select that cell and look at the formula bar, you'll see the date.

In fact, if you format the cell as General, you'll see:
38740

(which is the number of days since December 31, 1899. That date is equal to 0
to excel. Excel just keeps adding one to for every day passed since then.)

It's what makes date arithmetic so easy to do:

=today()+7
is a week from today.

Hi, I got it. But if the cell isnt custom formatted, i.e general, how to
refer?

 

[crapit]

What I want to ck is to see whether tat particular cell B1 = sun, since that
cell value is an evaluation, I dont know how to determine it!

 

[crapit]

Hi, I got it. But if the cell isnt custom formatted, i.e general, how to
refer?