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

Highlight the cells that you want to change then hit:-

Ctrl and the ; key simultaneously.

The current date will be placed into the highlighted cells.

Please hit Yes if my comments have helped.

Thanks!





"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?