View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
bo922
 
Posts: n/a
Default How do I do a formula to update numbers daily?

I have a number in my spreadsheet. I need that number to go up everytime I
open the spreadsheet. Example, the number on the spreadsheet is 2. When I
open it up 7 days from now, I need the number in the spreadsheet to be 9 (2
plus the 7 days from when I last opened the file).