counting days
 

Hi,
is it possible to have a cell on a worksheet that
automaticaly produces the date ie =TODAY() then in
another (hidden) cell show that date as a number.
for example if the date placed was 3rd Feb 2005 the
hidden cell would show 3 as this is the 3rd day, or if
the date shown was 21st Feb 2005, the cell would show 21
as this is day 21 of the month.

Hope I have made myslef clear, and thanks in advance

=day(A1)

How will it show anything if it is hidden?

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Anthony" wrote in message
...
Hi,
is it possible to have a cell on a worksheet that
automaticaly produces the date ie =TODAY() then in
another (hidden) cell show that date as a number.
for example if the date placed was 3rd Feb 2005 the
hidden cell would show 3 as this is the 3rd day, or if
the date shown was 21st Feb 2005, the cell would show 21
as this is day 21 of the month.

Hope I have made myslef clear, and thanks in advance

hi,
assuming that your date in in Cell A1,
in the hidden cell(?) enter
=Day(A1)
-----Original Message-----
Hi,
is it possible to have a cell on a worksheet that
automaticaly produces the date ie =TODAY() then in
another (hidden) cell show that date as a number.
for example if the date placed was 3rd Feb 2005 the
hidden cell would show 3 as this is the 3rd day, or if
the date shown was 21st Feb 2005, the cell would show 21
as this is day 21 of the month.

Hope I have made myslef clear, and thanks in advance
.

Bob,
thanks for that, it will only be hidden as I wish to use
this 'day value' as part of a calculation in another
sheet, so it is does'nt need to be seen in the orig
worksheet.
thanks for your post
-----Original Message-----
=day(A1)

How will it show anything if it is hidden?

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Anthony" wrote in
message
...
Hi,
is it possible to have a cell on a worksheet that
automaticaly produces the date ie =TODAY() then in
another (hidden) cell show that date as a number.
for example if the date placed was 3rd Feb 2005 the
hidden cell would show 3 as this is the 3rd day, or if
the date shown was 21st Feb 2005, the cell would show
21
as this is day 21 of the month.

Hope I have made myslef clear, and thanks in advance


.

Then wouldn't you just use it directly in that calculation? What advantage
does an intermediary cell hold in this instance?

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Anthony" wrote in message
...
Bob,
thanks for that, it will only be hidden as I wish to use
this 'day value' as part of a calculation in another
sheet, so it is does'nt need to be seen in the orig
worksheet.
thanks for your post
-----Original Message-----
=day(A1)

How will it show anything if it is hidden?

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Anthony" wrote in
message
...
Hi,
is it possible to have a cell on a worksheet that
automaticaly produces the date ie =TODAY() then in
another (hidden) cell show that date as a number.
for example if the date placed was 3rd Feb 2005 the
hidden cell would show 3 as this is the 3rd day, or if
the date shown was 21st Feb 2005, the cell would show
21
as this is day 21 of the month.

Hope I have made myslef clear, and thanks in advance


.