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

as above

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

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" <sweet_dreams@o2.pl> wrote in message
news:1138017127.286822.27280@o13g2000cwo.googlegroups.com...
> 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
>

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.



crapit wrote:
>
> 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" <sweet_dreams@o2.pl> wrote in message
> news:1138017127.286822.27280@o13g2000cwo.googlegroups.com...
> > 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

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!

"Dave Peterson" <petersod@verizonXSPAM.net> wrote in message
news:43D4EACF.157C4475@verizonXSPAM.net...
> 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.
>
>
>
> crapit wrote:
>>
>> 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" <sweet_dreams@o2.pl> wrote in message
>> news:1138017127.286822.27280@o13g2000cwo.googlegroups.com...
>> > 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

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

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



crapit wrote:
>
> 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!
>
> "Dave Peterson" <petersod@verizonXSPAM.net> wrote in message
> news:43D4EACF.157C4475@verizonXSPAM.net...
> > 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.
> >
> >
> >
> > crapit wrote:
> >>
> >> 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" <sweet_dreams@o2.pl> wrote in message
> >> news:1138017127.286822.27280@o13g2000cwo.googlegroups.com...
> >> > 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

--

Dave Peterson

Hi, I got it. But if the cell isnt custom formatted, i.e general, how to
refer?
"Dave Peterson" <petersod@verizonXSPAM.net> wrote in message
news:43D5347B.39D9EE4E@verizonXSPAM.net...
> If you look at excel's help for =weekday(), you'll find one way:
>
> =weekday(a1,1)=1
> or
> =weekday(a1,2)=7
>
>
>
> crapit wrote:
>>
>> 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!
>>
>> "Dave Peterson" <petersod@verizonXSPAM.net> wrote in message
>> news:43D4EACF.157C4475@verizonXSPAM.net...
>> > 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.
>> >
>> >
>> >
>> > crapit wrote:
>> >>
>> >> 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" <sweet_dreams@o2.pl> wrote in message
>> >> news:1138017127.286822.27280@o13g2000cwo.googlegroups.com...
>> >> > 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
>
> --
>
> 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.

crapit wrote:
>
> Hi, I got it. But if the cell isnt custom formatted, i.e general, how to
> refer?
> "Dave Peterson" <petersod@verizonXSPAM.net> wrote in message
> news:43D5347B.39D9EE4E@verizonXSPAM.net...
> > If you look at excel's help for =weekday(), you'll find one way:
> >
> > =weekday(a1,1)=1
> > or
> > =weekday(a1,2)=7
> >
> >
> >
> > crapit wrote:
> >>
> >> 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!
> >>
> >> "Dave Peterson" <petersod@verizonXSPAM.net> wrote in message
> >> news:43D4EACF.157C4475@verizonXSPAM.net...
> >> > 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.
> >> >
> >> >
> >> >
> >> > crapit wrote:
> >> >>
> >> >> 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" <sweet_dreams@o2.pl> wrote in message
> >> >> news:1138017127.286822.27280@o13g2000cwo.googlegroups.com...
> >> >> > 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
> >
> > --
> >
> > Dave Peterson

--

Dave Peterson