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

[erie2446]

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?

 

[Mattlynn via OfficeKB.com]

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

 

[berniean]

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

 

[David Biddulph]

=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.