How do a set the current date to change in cell everyday
 

I have a created a spreadsheet that calulates the number of days between two
dates. Since I have 30 entries to track I must change the current date in 30
cells. However, I have to manually change the current date in 30 cells. Is
there a formula to automatically change the current day in the cells?

How do a set the current date to change in cell everyday
 

Try setting a date in just one sheet, (sheet 1 cell A1) and having all the
other sheets set as =a1(sheet1!)




erie2446 wrote:
I have a created a spreadsheet that calulates the number of days between two
dates. Since I have 30 entries to track I must change the current date in 30
cells. However, I have to manually change the current date in 30 cells. Is
there a formula to automatically change the current day in the cells?

--
Matt Lynn

Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200910/1

How do a set the current date to change in cell everyday
 

in the cells that have to have the current date use =Now()

or

place =Now() in a single cell (e.g., A1) and have the cells that have the
current date point to that cell =A1

"erie2446" wrote:

I have a created a spreadsheet that calulates the number of days between two
dates. Since I have 30 entries to track I must change the current date in 30
cells. However, I have to manually change the current date in 30 cells. Is
there a formula to automatically change the current day in the cells?

How do a set the current date to change in cell everyday
 

I think you meant =Sheet1!A1


Gord Dibben MS Excel MVP

On Fri, 16 Oct 2009 13:24:29 GMT, "Mattlynn via OfficeKB.com" <u44078@uwe
wrote:

Try setting a date in just one sheet, (sheet 1 cell A1) and having all the
other sheets set as =a1(sheet1!)




erie2446 wrote:
I have a created a spreadsheet that calulates the number of days between two
dates. Since I have 30 entries to track I must change the current date in 30
cells. However, I have to manually change the current date in 30 cells. Is
there a formula to automatically change the current day in the cells?

How do a set the current date to change in cell everyday
 

=TODAY() will do.
=NOW() gives time as well as date, so you'd get a false result if you try to
compare it with today's date.
--
David Biddulph

berniean wrote:
in the cells that have to have the current date use =Now()

or

place =Now() in a single cell (e.g., A1) and have the cells that have
the current date point to that cell =A1

"erie2446" wrote:

I have a created a spreadsheet that calulates the number of days
between two dates. Since I have 30 entries to track I must change
the current date in 30 cells. However, I have to manually change the
current date in 30 cells. Is there a formula to automatically change
the current day in the cells?

How do a set the current date to change in cell everyday
 

Yer - Thanks Gord.

Gord Dibben wrote:
I think you meant =Sheet1!A1

Gord Dibben MS Excel MVP

Try setting a date in just one sheet, (sheet 1 cell A1) and having all the
other sheets set as =a1(sheet1!)
[quoted text clipped - 3 lines]
cells. However, I have to manually change the current date in 30 cells. Is
there a formula to automatically change the current day in the cells?

--
Matt Lynn

Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200910/1

How do a set the current date to change in cell everyday
 

Darn clunky fingers<g


Gord

On Mon, 19 Oct 2009 10:42:39 GMT, "Mattlynn via OfficeKB.com" <u44078@uwe
wrote:

Yer - Thanks Gord.

Gord Dibben wrote:
I think you meant =Sheet1!A1

Gord Dibben MS Excel MVP

Try setting a date in just one sheet, (sheet 1 cell A1) and having all the
other sheets set as =a1(sheet1!)
[quoted text clipped - 3 lines]
cells. However, I have to manually change the current date in 30 cells. Is
there a formula to automatically change the current day in the cells?