counting days

[Anthony]

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 Phillips]

=day(A1)

How will it show anything if it is hidden?

--

HTH

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

 

[Guest]

hi,
assuming that your date in in Cell A1,
in the hidden cell(?) enter
=Day(A1)

 

[Anthony]

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

 

[Bob Phillips]

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)