View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
erie2446 erie2446 is offline
external usenet poster
 
Posts: 1
Default 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?